Skip to main content

A data analysis toolkit for the KFW lab (Windows)

Project description

KFWY Data Analysis Toolkit

This is a toolkit for Windows that automatically analyzes data for assays.

  1. Installing KFWY
  2. Tools Available
  3. Using the Data Analysis Tools (Tools 1-3)
  4. Using the Merge Tools (Tools 4-6)
  5. Understanding the Output

Installing KFWY

  1. Ensure that Python 2.7 is installed (preferably the latest version).
    • Open your Command prompt and run the command python --version.
    • If the response is Python 2.7.XX then you have the correct version of Python installed. Otherwise, you should download the latest Python 2.7 Windows installer, open the installer, and follow the installation instructions (Python 2.7.15 is the latest at this time) https://www.python.org/downloads/release/python-2715/.
    • NOTE: If you think Python is installed but the above command does not work, try the command C:\Python27\python.exe --version. If this command works but not the above command, then consider following these instructions to add python to your PATH environment variables.
      1. Open the Advanced System Settings.
      2. Click Environment Variables.
      3. Select New.
      4. Enter python as the Variable Name and C:\Python27 as the Variable Value.
      5. Restart your Command prompt.
    • If you choose not to do this, then you must replace python with C:\Python27\python.exe from here on out.
  2. Make sure that pip is installed. If you have the latest version of Python 2.7, then pip should already be installed.
    • Run the command pip --version.
    • If the response is pip XX.X from ... (python 2.7) then you have the correct version of pip installed. Otherwise, you should follow the installation instructions at https://ehmatthes.github.io/pcc/chapter_12/installing_pip.html#pip-on-os-x.
    • NOTE: If you think pip is installed but the above command does not work, try the command C:\Python27\Scripts\pip.exe --version. If this command works but not the above command, then consider following these instructions to add pip to your PATH environment variables.
      1. Open the Advanced System Settings.
      2. Click Environment Variables.
      3. Double click the Path variable.
      4. Select New.
      5. Enter C:\Python27\Scripts.
      6. Restart your Command prompt.
    • If you choose not to do this, then you must replace pip with C:\Python27\Scripts\pip.exe from here on out.
  3. Install kfwy from the Python Package Index with pip.
    • Type the command pip install --upgrade kfwy.
  4. You must have also some other Python modules installed.
    • matplotlib
    • pandas
    • seaborn
    • xlrd
    • openpyxl Use the command pip install matplolib pandas seaborn xlrd openpyxl. This may take a few minutes to finish.

Tools Available

  1. Membrane Potential
  2. NADH Redox
  3. H2O2
  4. Membrane Potential Merge
  5. NADH Redox Merge
  6. H2O2 Merge

Using the Data Analysis Tools (Tools 1-3)

  1. Place the raw data files (.txt) to be analyzed in a folder.
  2. Open the command line
  3. Navigate to the folder
    • e.g. if folder path is users/data_analysis, then type the command cd users/data_analysis
  4. Type command python -m kfwy to run

Using the Merge Tools (Tools 4-6)

  1. Place the excel files (.xlsx) to be merged in a folder.
  2. Open the command line
  3. Navigate to the folder
    • e.g. if folder path is users/data_analysis, then type the command "cd users/data_analysis" without quotations
  4. Type command python -m kfwy to run

Understanding the Output

This section explains in detail the significance of the results of the data analysis.

Membrane Potential

  1. Metadata Sheet - This sheet hosts information about the experiment itself
    • ID - The experimental ID.
    • Standard Curve - A true or false value indicating whether or not the standard curve calculation was used.
    • Slope - The slope value entered by the researcher to be used in calculations.
    • Y-Intercept - The y-intercept value entered by the researcher to be used in calculations.
    • Substrates - A column containing the list of substrates used in the experiment.
    • Additions - A column containing the list of additions used in the experiment.
    • Date - The date the analysis was run in the form YYYY-MM-DD.
  2. Raw Data - The raw data taken from the lab tools.
    • The data is in the form X | Y | X |...
  3. Averaged Raw Data - The average membrane potential for 3-minute (i.e., 180 seconds) increments in each data set. Each data set is annotated with the buffer conditions of the assay at that time.
  4. Corrected Raw Data - The same data as the Average Raw Data sheet, but with an additional correction calculation which divides each average membrane potential by the the average membrane potential for Ala.
  5. Standard Curve Data - The results of the standard curve calculation on the raw data.
    • The data is in the form X | Y | X |...
  6. Averaged Standard Curve - The results of the standard curve calculation on the averaged data.

NADH Redox

  1. Metadata Sheet - This sheet hosts information about the experiment itself.
    • ID - The experimental ID.
    • Substrates - A column containing the list of substrates used in the experiment.
    • Additions - A column containing the list of additions used in the experiment.
    • Date - The date the analysis was run in the form YYYY-MM-DD.
  2. Raw Data - The raw data taken from the lab tools.
    • The data is in the form X | Y | X |...
  3. Stripped Data - Contains only the columns that correspond to the NADH data points.
    • The data is in the form X | Y | X |...
  4. Reduced Data - The same data as the Stripped Data sheet, but with an additional reduction calculation.
    • y_new = (y_old-min)/(max-min)*100
  5. Averaged Reduced Data - The averages of the reduced data for 3-minute (i.e., 180 seconds) increments in each data set. Each data set is annotated with the buffer conditions of the assay at that time.

H2O2

  1. Metadata Sheet - This sheet hosts information about the experiment itself
    • ID - The experimental ID.
    • Standard Curve - A true or false value indicating whether or not the standard curve calculation was used.
    • Slope - The slope value entered by the researcher to be used in calculations.
    • Y-Intercept - The y-intercept value entered by the researcher to be used in calculations.
    • Substrates - A column containing the list of substrates used in the experiment.
    • Additions - A column containing the list of additions used in the experiment.
    • Mitochondria - The amount of mitochondria use (in milligrams).
    • Date - The date the analysis was run in the form YYYY-MM-DD.
  2. Raw Data - The raw data taken from the lab tools.
    • The data is in the form X | Y | X |...
  3. Slopes Data - The slope for 3-minute (i.e., 180 seconds) increments in each data set. Each data set is annotated with the buffer conditions of the assay at that time.
  4. Corrected Slopes - The same data as the Slopes sheet, but with an additional correction calculation which divides each slope value by the mg of mitochondria used.
  5. Standard Curve - The results of the standard curve calculation on the Raw Data.
  6. Standard Curve Slopes - The results of the standard curve calculation on the Slopes Data.
  7. Corrected Standard Curve Slopes - The results of the correction calculation on the Standard Curve Slopes data.

Membrane Potential Merge

Combines data from all of the Averaged Standard Curve sheets in the Membrane Potential data analysis Excel files. Each row corresponds to a substrate. The Mean and SEM is calculated for each row.

NADH Redox Merge

Combines data from all of the Averaged Reduced Data sheets in the NADH Redox data analysis Excel files. Each row corresponds to a substrate. The Mean and SEM is calculated for each row.

H2O2 Merge

Combines data from all of the Corrected Standard Curve Slopes sheets in the H2O2 data analysis Excel files. Each row corresponds to a substrate. The Mean and SEM is calculated for each row.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

kfwy-0.0.17.tar.gz (12.9 kB view details)

Uploaded Source

Built Distribution

kfwy-0.0.17-py2-none-any.whl (24.8 kB view details)

Uploaded Python 2

File details

Details for the file kfwy-0.0.17.tar.gz.

File metadata

  • Download URL: kfwy-0.0.17.tar.gz
  • Upload date:
  • Size: 12.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.5.0.1 requests/2.20.1 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.29.1 CPython/2.7.15

File hashes

Hashes for kfwy-0.0.17.tar.gz
Algorithm Hash digest
SHA256 d5b54ea06499f2a0dc6603613dd16eab5c227d4293710ce490f0b85b19ae579d
MD5 0cf650128ef0b251becf320f6c159b4c
BLAKE2b-256 901d184abfdee0ddd3b539d8815229df243c5469c96233f4f12a1a49b78327d9

See more details on using hashes here.

File details

Details for the file kfwy-0.0.17-py2-none-any.whl.

File metadata

  • Download URL: kfwy-0.0.17-py2-none-any.whl
  • Upload date:
  • Size: 24.8 kB
  • Tags: Python 2
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.5.0.1 requests/2.20.1 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.29.1 CPython/2.7.15

File hashes

Hashes for kfwy-0.0.17-py2-none-any.whl
Algorithm Hash digest
SHA256 cfb5e10923120567c366ee6a865ff8657f7b494c9a88198bec2d850f93625e1e
MD5 e014876f35627ab98a1d2b5931b6c770
BLAKE2b-256 6c3ae55622a8c13575cae5c40bce9391a44573772b164476378c138e8470712a

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page