alhankeser/citibike-analysis

Optimize weather data cleaning query

Closed this issue · 0 comments

Related to #3 : improve performance of query

df_weather_na['latitude'] = df_weather_na['zip'].apply(lambda x: df[df['zip'] == x]['latitude'].unique()[0])
df_weather_na['longitude'] = df_weather_na['zip'].apply(lambda x: df[df['zip'] == x]['longitude'].unique()[0])