這是一些將生成一些隨機(jī)時(shí)間序列數(shù)據(jù)的代碼。最終，我試圖將每天的數(shù)據(jù)保存到單獨(dú)的CSV文件中...import pandas as pd import numpy as np from numpy.random import randint np.random.seed(10) # added for reproductibility rng = pd.date_range('10/9/2018 00:00', periods=1000, freq='1H') df = pd.DataFrame({'Random_Number':randint(1, 100, 1000)}, index=rng)我可以用這個(gè)打印每天的數(shù)據(jù)：for idx, days in df.groupby(df.index.date): print(days)但是，如何將保存的單個(gè)CSV文件合并到一個(gè)目錄中，每個(gè)文件都以第一個(gè)時(shí)間戳條目月份和日期命名？（下面的代碼不起作用）csvfor idx, days in df.groupby(df.index.date): for day in days: df2 = pd.DataFrame(list(day)) month_num = df.index.month[0] day_num = df.index.day[0] df2.to_csv('/csv/' + f'{month_num}' + '_' + f'{day_num}' + '.csv')
1 回答
撒科打諢
TA貢獻(xiàn)1934條經(jīng)驗(yàn) 獲得超2個(gè)贊
您可以遍歷所有可用天數(shù)，過濾數(shù)據(jù)幀，然后保存。
# iterate over all available days
for date in set(df.index.date):
# filter your dataframe
filtered_df = df.loc[df.index.date == date].copy()
# save it
filename = date.strftime('%m_%d') # filename represented as 'month_day'
filtered_df.to_csv(f"./csv/{filename}.csv")
添加回答
舉報(bào)
0/150
提交
取消