I am working on COVID 19 DATA FOR CALIFORNIA since time long now. when I print code, I get answer, ok. Sololearn, refuse. Help

Question

import pandas as pd

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

df.drop('state', axis=1, inplace=True)
df['date'] = pd.to_datetime(df['date'], format="%d.%m.%y")

df.set_index('date', inplace=True)
df['ratio']=df['deaths']/(df['cases'])
df=df[df[('ratio')]==(df['ratio'].max())]
print (df)

Answer 1

Israel Mutebi ,

this line is causing the problem:

...
df['date'] = pd.to_datetime(df['date'], format="%d.%m.%y")
...

duplicate your code and run it in the playground in one run:

-> version with this line
-> version without this line

watch the format of the date value !!!

Answer 2

Israel Mutebi ,

the *.csv file that we load from sololearn looks like:

date, state, cases, deaths
25.01.20, California,1,0
...

the date format is day.month.year(only last 2 digits) as a string. since there is no advice to modify that format, we do not need to re-format the data of this column. just omit the line i mentioned in my previous post.

this is what the mentioned line is performing:
the line of code converts the 'date' column from a string format (supplied from the *.csv file) to a 'datetime' object. since the code has only given the input format, it will be converted to a default format.

using the code without the mentioned line has passed the test case in the exercice, so it is seen as correct.

Answer 3

Lothar Thanks.
I had to remove all 3 lines.

Solved
I couldn't do this without you
...

Answer 4

Please help me understand the difference

Answer 5

Thanks Lothar
I get this output in code playground meaning the code is correct?

Date cases. Death ratio
2020-03-10. 7. 1. 0.142857

But my sololearn still refuse my answer?
Would I be able to get that result with a wrong code??? Help