Difference between revisions of "Asandle1 Week 14"
Jump to navigation
Jump to search
(→In Class Thursday April 18th Notes: added sheet) |
(→April 23 Notes: notes added) |
||
(15 intermediate revisions by the same user not shown) | |||
Line 14: | Line 14: | ||
* We are now thinking about what to put down for metadata, I asked what we need for metadata and Dr. Dahlquist is explaining to us what metadata is and what to put in for it. | * We are now thinking about what to put down for metadata, I asked what we need for metadata and Dr. Dahlquist is explaining to us what metadata is and what to put in for it. | ||
* Added a sheet and named it Metadata | * Added a sheet and named it Metadata | ||
+ | * Added a Primary Key, Description, Data Source, Date Accessed, Data Updated Date, and Publication (Pubmed ID) or DOI Column | ||
+ | * Entered the info under each of these sections, and shared a screenshot with Dean to make sure we don't do the same work twice | ||
+ | ---- | ||
− | + | ===April 21 Notes=== | |
+ | * Trying to get in touch with to see where he left off so I know where to progress for next steps | ||
− | == | + | ===April 22 Notes=== |
+ | * Dean looks to have created 4 of the tables but I need to speak with him in person to make corrections | ||
+ | * Created the metadata table | ||
+ | * Added detailed descriptions for table items | ||
+ | * Access File is on Box in each iteration, uploaded most recent version to box. | ||
+ | ===April 23 Notes=== | ||
+ | #Issue with Degradation rates and production rates on access going to 0's and 1's. | ||
+ | # I told Dean to ignore this issue and I will Deal with it while he deals with the expression table. | ||
+ | # Dr. Dahlquist tried reimporting and it works, so I am going to import both Degradation_Rates and Production_Rates again. | ||
+ | # I tried importing and had no issues | ||
+ | # Fixed the issues and everything worked fine | ||
+ | # Dean is working on the Expression_Table right now while I was fixing these. He encountered some issues for the Data team to solve. | ||
+ | # Dean said there is an error in the Network table. He said he can't make something a primary key because of a null value. I told him thats an excel importing issue, and we need to fix it in excel. I told Dean I will deal with it because he is not understanding the issue. | ||
+ | # I connected all of the relationships for the primary keys. Meta data remains unconnected since it is a separate piece. | ||
+ | ==References & Acknowledgements== | ||
+ | ===Acknowlegements=== | ||
+ | * Dean and I communicated about the project via text, at one point I didn't hear from him so I called him and he promptly got back to me. | ||
+ | * Dr. Dahlquist helped us solve some issues with the data in the production_rates and degradation_rates tables. She also provided assistance with the expression table. | ||
+ | ===References=== | ||
#LMU BioDB 2024. (2024). Coder/Designer. Retrieved April 17, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Coder/Designer | #LMU BioDB 2024. (2024). Coder/Designer. Retrieved April 17, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Coder/Designer | ||
#Community Central Fandom. (2024). Forum:How do I link to a heading on another page?. Retrieved April 17, 2024, from https://community.fandom.com/wiki/Forum:How_do_I_link_to_a_heading_on_another_page%3F | #Community Central Fandom. (2024). Forum:How do I link to a heading on another page?. Retrieved April 17, 2024, from https://community.fandom.com/wiki/Forum:How_do_I_link_to_a_heading_on_another_page%3F |
Latest revision as of 13:49, 23 April 2024
To User Page: User: Asandle1 To Template: Template:Asandle1
Contents
Assignment Pages
Journals
Individual
Class Journals
Electronic Lab Notebook
To get to the Team Journal Page please click here: Yeast Beasts To get to the Previous Journal click here: Asandle1 Week 13
In Class Thursday April 18th Notes
- Dean immediately told me he needed help getting the text for the degradation imported
- I told him I knew how to fix it and he just needed to import the text to excel instead of copy pasting. Dr. Dahlquist helped him with that.
- we solved the issue of the #REF and Blanks, we didn't end up needing those two columns so we just deleted them
- Dean shared into the box up to the additional steps he took.
- Everything is into the file and we are having the other group look over what we did.
- We are now thinking about what to put down for metadata, I asked what we need for metadata and Dr. Dahlquist is explaining to us what metadata is and what to put in for it.
- Added a sheet and named it Metadata
- Added a Primary Key, Description, Data Source, Date Accessed, Data Updated Date, and Publication (Pubmed ID) or DOI Column
- Entered the info under each of these sections, and shared a screenshot with Dean to make sure we don't do the same work twice
April 21 Notes
- Trying to get in touch with to see where he left off so I know where to progress for next steps
April 22 Notes
- Dean looks to have created 4 of the tables but I need to speak with him in person to make corrections
- Created the metadata table
- Added detailed descriptions for table items
- Access File is on Box in each iteration, uploaded most recent version to box.
April 23 Notes
- Issue with Degradation rates and production rates on access going to 0's and 1's.
- I told Dean to ignore this issue and I will Deal with it while he deals with the expression table.
- Dr. Dahlquist tried reimporting and it works, so I am going to import both Degradation_Rates and Production_Rates again.
- I tried importing and had no issues
- Fixed the issues and everything worked fine
- Dean is working on the Expression_Table right now while I was fixing these. He encountered some issues for the Data team to solve.
- Dean said there is an error in the Network table. He said he can't make something a primary key because of a null value. I told him thats an excel importing issue, and we need to fix it in excel. I told Dean I will deal with it because he is not understanding the issue.
- I connected all of the relationships for the primary keys. Meta data remains unconnected since it is a separate piece.
References & Acknowledgements
Acknowlegements
- Dean and I communicated about the project via text, at one point I didn't hear from him so I called him and he promptly got back to me.
- Dr. Dahlquist helped us solve some issues with the data in the production_rates and degradation_rates tables. She also provided assistance with the expression table.
References
- LMU BioDB 2024. (2024). Coder/Designer. Retrieved April 17, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Coder/Designer
- Community Central Fandom. (2024). Forum:How do I link to a heading on another page?. Retrieved April 17, 2024, from https://community.fandom.com/wiki/Forum:How_do_I_link_to_a_heading_on_another_page%3F
Used week 13 as an outline Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Asandle1 (talk)