Has anyone passed the COVID Test in Python for Data Science course?

Question

Hi All! If yes, could you answer for a few questions which maybe allows me to go closer to the answer? And it is not about the solution... not an exact one at least ;-)
1. First of all, is it possible? As I have been trying for weeks... probably I am not good enough :-(
2. What is the exact format of the output? As this is somethimes the key to pass the test.
3. Is the answer date from the first quater of the year?
4. And the ratio between 0.08 and 0.16?
Maybe someone who has not done this course and is PRO can look at that challenge and give me some advises.
TIA :-)

Answer 1

Calvin Thomas here means where?

Answer 2

Calvin Thomas Projects have no discussion section. I asked this question, maybe in less descriptive way, in the last lesson, but was no answer. That's why I put it here 🙂

Answer 3

blackfish Please post the question here.

Answer 4

The output should be a row of the df with the highest ratio:
i = df['ratio'].max()
print(df[(df['ratio']==i)])

Answer 5

import pandas as pd

df = pd.read_csv("/usercode/files/ca-covid.csv")

df.drop('state', axis=1, inplace=True)
df.set_index('date', inplace=True)
de = df['deaths']/df['cases']
df['ratio'] = de
i = df['ratio'].max()
print(df[(df['ratio']==i)])

Answer 6

blackfish The comments section, I mean.

Answer 7

blackfish I see.

Answer 8

Daniel Thank you. However I did not want the code. I already solved it on my own, but could not pass the test. The reason was a wrong question/description of the task. It says:
"Important: The output should be a DataFrame, containing all of the columns of the dataset for the corresponding row."
"All of the columns" means for me "State" column too. Thanks to you I add these two lines of code: removing "state" column and sorting by date.