Difference between revisions of "Simplest Example of Assignment"

From PharmWiki
Jump to navigation Jump to search
(Created page with "= Dealing with MS Excel data in Python = * OpenPyxl")
 
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
= Dealing with MS Excel data in Python =
= 1. Produce some hypothetical MS Excel Data =


* [[OpenPyxl]]
* '''Reference:''' [https://openpyxl.readthedocs.io/en/stable/tutorial.html OpenPyxl Tutorial]
*The easiest is on the far left, which is manually editing the MS Excel, but you can also produce it with Python by various methods.
*You can use any one or all the methods. That is up to you.
 
{| class="wikitable"
|+Different Options for Producing the MS Excel Data
!
!Manually
Altering
 
Data
!JupyterLab
IDE
!Spyder
IDE
!JupyterLab
IDE
!JupyterLab
IDE
 
(with fancy tables)
!Spyder IDE
!Spyder IDE
|-
!Type
!
!Simple
!Simple
!Detailed
!Detailed with fancy tables
!Detailed
!Detailed with fancy tables
|-
|Program
|[[Media:WesternBlot.xlsx|WesternBlot.xlsx]]
|[[Media:Make Data-Simple.ipynb|Make_Data-Simple.ipynb]]
|[[Media:Make Data-Simple.py|Make_Data-Simple.py]]
|[[Media:Make Data.ipynb|Make_Data.ipynb]]
|[[Media:Make Data+Tables.ipynb|Make_Data+Tables.ipynb]]
|[[Media:Make Data.py|Make_Data.py]]
|[[Media:Make Data+Tables.py|Make_Data+Tables.py]]
|}
 
= 2. Read and Analyze the MS Excel Data =
 
# Choose one of the options above. Put the WesternBlot.xlsx data in the same directory as the Jupyter notebook file (ipynb) or the python scripts (py).
#Run the Jupyter notebook (ipynb) or the python script (py) below.
{| class="wikitable"
|+Read and Analyze the MS Excel Data
!JupyterLab
IDE
!Spyder
IDE
!Output Data
|-
|[[Media:Read and Analyze Data.ipynb|Read_and_Analyze_Data.ipynb]]
|[[Media:Read and Analyze Data.py|Read_and_Analyze_Data.py]]
|[[Media:WesternBlot-Analyzed.xlsx|WesternBlot-Analyzed.xlsx]]
|}
 
= 3. Read and Graph the Analyzed MS Excel Data =
 
# Take the file that your produced above in the example it is WesternBlot-Analyzed.xlsx.
# Run the Jupyter notebook (ipynb) or the python script (py) below
 
{| class="wikitable"
|+Read and Graph the Analyzed MS Excel Data
!JupyterLab
IDE
!Spyder
IDE
!Trials Output
!Stats Output
|-
|[[Media:Read and Graph Data.ipynb|Read_and_Graph_Data.ipynb]]
|[[Media:Read and Graph Data.py|Read_and_Graph_Data.py]]
|[[File:Trials2.png|frameless]]
|[[File:Stats2.png|frameless]]
|}
 
= 4. What to send me =
 
# In step #1, change the numbers of Protein #1, Protein #2 and Protein #3 using the MS Excel file or the Jupyter notebooks or the python programs.
# Run your data through steps #2 and #3.
# Put MS Excel, Jupyter Notebooks, and Python files that you used for the individual steps into a folder labeled '''Assignment1'''
# Put the Trials Output and the Stats Output figure into an MS Word Document and put it into '''Assignment1'''
#* The following is the MS Word document used with the data above named [[media:Westerblot.docx|Westernblot.docx]].
# Zip compress the '''Assignment1''' folder and email it to me.

Latest revision as of 23:47, 28 March 2022

1. Produce some hypothetical MS Excel Data

  • Reference: OpenPyxl Tutorial
  • The easiest is on the far left, which is manually editing the MS Excel, but you can also produce it with Python by various methods.
  • You can use any one or all the methods. That is up to you.
Different Options for Producing the MS Excel Data
Manually

Altering

Data

JupyterLab

IDE

Spyder

IDE

JupyterLab

IDE

JupyterLab

IDE

(with fancy tables)

Spyder IDE Spyder IDE
Type Simple Simple Detailed Detailed with fancy tables Detailed Detailed with fancy tables
Program WesternBlot.xlsx Make_Data-Simple.ipynb Make_Data-Simple.py Make_Data.ipynb Make_Data+Tables.ipynb Make_Data.py Make_Data+Tables.py

2. Read and Analyze the MS Excel Data

  1. Choose one of the options above. Put the WesternBlot.xlsx data in the same directory as the Jupyter notebook file (ipynb) or the python scripts (py).
  2. Run the Jupyter notebook (ipynb) or the python script (py) below.
Read and Analyze the MS Excel Data
JupyterLab

IDE

Spyder

IDE

Output Data
Read_and_Analyze_Data.ipynb Read_and_Analyze_Data.py WesternBlot-Analyzed.xlsx

3. Read and Graph the Analyzed MS Excel Data

  1. Take the file that your produced above in the example it is WesternBlot-Analyzed.xlsx.
  2. Run the Jupyter notebook (ipynb) or the python script (py) below
Read and Graph the Analyzed MS Excel Data
JupyterLab

IDE

Spyder

IDE

Trials Output Stats Output
Read_and_Graph_Data.ipynb Read_and_Graph_Data.py Trials2.png Stats2.png

4. What to send me

  1. In step #1, change the numbers of Protein #1, Protein #2 and Protein #3 using the MS Excel file or the Jupyter notebooks or the python programs.
  2. Run your data through steps #2 and #3.
  3. Put MS Excel, Jupyter Notebooks, and Python files that you used for the individual steps into a folder labeled Assignment1
  4. Put the Trials Output and the Stats Output figure into an MS Word Document and put it into Assignment1
    • The following is the MS Word document used with the data above named Westernblot.docx.
  5. Zip compress the Assignment1 folder and email it to me.