e-Stat から市区町村データをダウンロードして整形したときの記録

e-stat_cities.csv

e-stat_cities.py

import pandas as pd

df = pd.read_csv("e-stat.csv", encoding='cp932')
city_code = df.iloc[:, 2]
prefecture = df.iloc[:, 3].map(lambda s: s.split(' ')[0])
city = df.iloc[:, 3].map(lambda s: s.split(' ')[1])
pop = df.iloc[:, 5]
age = df.iloc[:, 8]
working_age_pop = df.iloc[:, 9]
daytime_pop = df.iloc[:, 15]
df2 = pd.DataFrame({
    'city_code': city_code,
    'prefecture': prefecture,
    'city': city,
    'pop': pop,
    'age': age,
    'working_age_pop': working_age_pop,
    'daytime_pop': daytime_pop
})
df2.to_csv('e-stat_cities.csv', index=False, encoding='utf-8')