CSVデータの検索、集計をPython3.8で作ってみた。
【Python3.8】
import openpyxl as px
import pandas as pd
import datetime
import time
dt_now_s = datetime.datetime.now()
start = time.time()
book = px.load_workbook('test_2.xlsx')
now = book.active#Excelシート設定
df = pd.read_csv('test_1.csv', index_col=1)#index設定”1”=B列
print(df)
vc = df['f'].value_counts()
print(vc)
#Excelセル文字をkeyで繰り返す
for i in range(5000):
some = "A" + str(i + 1)
somex = "B" + str(i + 1)
key = (now[some].value)
print(key)
print(df.at[key,'f'])
now[somex].value = df.at[key,'f']#index設定”1”=B列とkeyを比較
i += 1
book.save('test_2.xlsx')
dt_now_e = datetime.datetime.now()
print(dt_now_s)
print(dt_now_e)
dt = dt_now_e - dt_now_s
print(dt)
t = time.time() - start
print(t)