import io
import time
import pandas as pd
import requests
key = ""
def get_list_csv(word):
params = {
"appId" : key,
"lang": "J" ,
}
params["searchWord"] = word
r = requests.get(
"https://api.e-stat.go.jp/rest/3.0/app/getSimpleStatsList", params=params
)
return r.content
def get_data_csv(id):
params = {
"appId": key,
"lang": "J",
"metaGetFlg": "Y",
"cntGetFlg": "N",
"sectionHeaderFlg": "1",
}
params["statsDataId"] = id
r = requests.get(
"https://api.e-stat.go.jp/rest/3.0/app/getSimpleStatsData", params=params
)
return r.content
res = get_list_csv("男女別学校数 NOT 後期課程")
df0 = pd.read_csv(io.BytesIO(r.content), skiprows=8, dtype=object)
stats = df0["TABLE_INF"].to_list()
dfs = []
for stat in stats:
res = get_data_csv(stat)
df1 = pd.read_csv(io.BytesIO(r.content), skiprows=28)
dfs.append(df1)
time.sleep(1)
df = pd.concat(dfs)