I have two Data Frames:
df_covid has "city" "state" "is_state" "cases confirmed" "deaths"
example:
city | state | is_state | cases confirmed | deaths |
---|---|---|---|---|
São Paulo | São Paulo | False | 10 | 1 |
NaN | São Paulo | True | 100 | 30 |
My second Data Frame is:
df_brasil:
city | latitude | longitude |
---|---|---|
São Paulo | -23.5329 | -46.6395 |
I want to create two columns on df_covid (latitude and longitude) based on df_brasil["city"] I tried:
for row in df_covid:
row["latitude"] = df_brasil.loc[df_brasil["city"] == row["city"]]["latitude"]
but it is taking so long to run (my df_covid is big) and I'm not sure if it is correct.