Facebook
From Kadir çallıoğlu, 1 Month ago, written in Python.
Embed
Download Paste or View Raw
Hits: 130
  1. import pandas as pd
  2. import numpy as np
  3.  
  4. # Read the CSV file
  5. df = pd.read_csv('/Users/Computer/Downloads/country_vaccination_stats.csv')
  6.  
  7.  
  8. min_vaccinations = df.groupby('country')['daily_vaccinations'].min()
  9.  
  10.  
  11. df['daily_vaccinations'] = df.groupby('country')['daily_vaccinations'].transform(lambda x: x.fillna(min_vaccinations[x.name]))
  12.  
  13.  
  14. df['daily_vaccinations'] = df['daily_vaccinations'].fillna(0).astype(np.int64)
  15.  
  16. print(df[df['daily_vaccinations'] == 0])
  17.