File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
import pandas as pd
import glob
files = glob.glob('영천시/*.csv')
for file in files:
df = pd.read_csv(file)
categories = ["상권업종대분류명", "상권업종중분류명", "상권업종소분류명", "표준산업분류명"]
out = []
for cat in categories:
num = df.value_counts(cat)
print(num)
out = pd.DataFrame(num, columns=['소상공인수'])
out.to_csv(f"{file.split('/')[-1]}_{cat}.csv")