Canadian temperature and precipitation 30 year averages for Canada from World Bank Climate Change Knowledge Portal

join-downloaded-climate-data.py

# download csv files from https://climateknowledgeportal.worldbank.org/download-data

import pandas as pd
import os

df = pd.DataFrame()
for root, dirs, files in os.walk('.'):
    for name in files:
        if name.endswith('.csv'):
            df2 = pd.read_csv(os.path.join(root, name), skiprows=1)
            df2['source'] = name
            df = df.append(df2)
df['Type'] = df['source'].str[0]
df['Type'].replace('p', 'precipitation', inplace=True)
df['Type'].replace('t', 'temperature', inplace=True)
df['Years'] = df['source'].str.split('_').str[4]
df.drop(columns=['source'], inplace=True)
df.rename(columns={'Unnamed: 0':'Location'}, inplace=True)
df

world-bank-climate-data-canada.csv