Application: Medical Data Analysis
Now do a slight variation of what you've learned to analyze a study on how the blood concentration of a certain drug evolves over time in the human body (important in the medical industry for optimizing dosage quantity and frequency). You'll also learn about logical indexing that will help avoid writing for loops and make your coding faster!
Task
- Identify the location of the Excel file;
- Import the data from the Excel file;
- Split the data based on the time concentration was measured (using logical indexing);
- Calculate descriptive statistics (minimum, maximum, mean, standard deviation) for each time across all patients in the study;
- Output the results to a new Excel file.
Organize your program into modular functions or components as you see fit.
Compare your program's results with the outputs shown in the video to ensure accuracy.
The video also highlights several convenient checkpoints where you can check your programming as you go along by either:
- Unsilencing variables (by removing the semicolon);
- Having your function temporarily output the variable in question.
Thanks for your feedback!
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 3.85Application: Medical Data Analysis
Swipe to show menu
Now do a slight variation of what you've learned to analyze a study on how the blood concentration of a certain drug evolves over time in the human body (important in the medical industry for optimizing dosage quantity and frequency). You'll also learn about logical indexing that will help avoid writing for loops and make your coding faster!
Task
- Identify the location of the Excel file;
- Import the data from the Excel file;
- Split the data based on the time concentration was measured (using logical indexing);
- Calculate descriptive statistics (minimum, maximum, mean, standard deviation) for each time across all patients in the study;
- Output the results to a new Excel file.
Organize your program into modular functions or components as you see fit.
Compare your program's results with the outputs shown in the video to ensure accuracy.
The video also highlights several convenient checkpoints where you can check your programming as you go along by either:
- Unsilencing variables (by removing the semicolon);
- Having your function temporarily output the variable in question.
Thanks for your feedback!
