Difference between revisions of "Emilysimso Week 12"

From LMU BioDB 2015
Jump to: navigation, search
(Started uploading files)
 
(Files: added first raw data edits)
Line 10: Line 10:
  
 
==Files==
 
==Files==
 +
===Choosing Appropriate Columns===
 +
*Downloaded each raw data file
 +
*Opened it using Xcel
 +
*Deleted unnecessary information at the top of the raw data tab
 +
*Created new tab with "Needed Columns" label
 +
*Transferred columns G, H, K, and L to this tab
 +
*Saved the file as a .xlsx file and uploaded to the wiki
 +
 +
 
*F1_1_Cy3: [[File:GSM496756 MR-1 F1 1 Cy3.xlsx]]
 
*F1_1_Cy3: [[File:GSM496756 MR-1 F1 1 Cy3.xlsx]]
 
*F1_1_Cy5: [[File:GSM496756 MR-1 F1 1 Cy5.xlsx]]
 
*F1_1_Cy5: [[File:GSM496756 MR-1 F1 1 Cy5.xlsx]]
Line 35: Line 44:
 
*F10_4_Cy5: [[File:GSM496767 MR-1 F10 4 Cy5.xlsx]]
 
*F10_4_Cy5: [[File:GSM496767 MR-1 F10 4 Cy5.xlsx]]
 
*F20_1_Cy3: [[File:GSM496768 MR-1 F20 1 Cy3.xlsx]]
 
*F20_1_Cy3: [[File:GSM496768 MR-1 F20 1 Cy3.xlsx]]
 +
*F20_1_Cy5: [[File:GSM496768 MR-1 F20 1 Cy5.xlsx]]
 +
*F20_2_Cy3: [[File:GSM496769 MR-1 F20 2 Cy3.xlsx]]
 +
*F20_2_Cy5: [[File:GSM496769 MR-1 F20 2 Cy5.xlsx]]
 +
*F20_3_Cy3: [[File:GSM496770 MR-1 F20 3 Cy3.xlsx]]
 +
*F20_3_Cy5: [[File:GSM496770 MR-1 F20 3 Cy5.xlsx]]
 +
*F20_4_Cy3: [[File:GSM496771 MR-1 F20 4 Cy3.xlsx]]
 +
*F20_4:Cy5: [[File:GSM496771 MR-1 F20 4 Cy5.xlsx]]
 +
*F40_1_Cy3: [[File:GSM496772 MR-1 F40 1 Cy3.xlsx]]
 +
*F40_1_Cy5: [[File:GSM496772 MR-1 F40 1 Cy5.xlsx]]
 +
*F40_2_Cy3: [[File:GSM496773 MR-1 F40 2 Cy3.xlsx]]
 +
*F40_2_Cy5: [[File:GSM496773 MR-1 F40 2 Cy5.xlsx]]
 +
*F40_3_Cy3: [[File:GSM496774 MR-1 F40 3 Cy3.xlsx]]
 +
*F40_3_Cy5: [[File:GSM496774 MR-1 F40 3 Cy5.xlsx]]
 +
*F40_4_Cy3: [[File:GSM496775 MR-1 F40 4 Cy3.xlsx]]
 +
*F40_4:Cy5: [[File:GSM496775 MR-1 F40 4 Cy5.xlsx]]
 +
*F60_1_Cy3: [[File:GSM496776 MR-1 F60 1 Cy3.xlsx]]
 +
*F60_1_Cy5: [[File:GSM496776 MR-1 F60 1 Cy5.xlsx]]
 +
*F60_2_Cy3: [[File:GSM496777 MR-1 F60 2 Cy3.xlsx]]
 +
*F60_2_Cy5: [[File:GSM496777 MR-1 F60 2 Cy5.xlsx]]
 +
*F60_3_Cy3: [[File:GSM496778 MR-1 F60 3 Cy3.xlsx]]
 +
*F60_3_Cy5: [[File:GSM496778 MR-1 F60 3 Cy5.xlsx]]
 +
*F60_4_Cy3: [[File:GSM496779 MR-1 F60 4 Cy3.xlsx]]
 +
*F60_4:Cy5: [[File:GSM496779 MR-1 F60 4 Cy5.xlsx]]

Revision as of 04:59, 20 November 2015

Goals

  • Normalize data, statistical analysis of raw data

File Notes

  • Will work on all "F" files
  • 52 chips total - 104 files (one for Cy3, one for Cy5)
  • sdrf file has 208 - duplicates
  • Need columns G, K, L, H
  • Log2 (Cy5 signal median-Cy5 signal background / Cy3 signal median - Cy3 signal background)

Files

Choosing Appropriate Columns

  • Downloaded each raw data file
  • Opened it using Xcel
  • Deleted unnecessary information at the top of the raw data tab
  • Created new tab with "Needed Columns" label
  • Transferred columns G, H, K, and L to this tab
  • Saved the file as a .xlsx file and uploaded to the wiki