對(duì)如何存儲(chǔ)、訪問和 mege dfs.c df 列具有相同的標(biāo)題名稱感到困惑。代碼如下：for s in range(40): # a func which returns historical business dates ago_Ybd_0= (date_by_adding_business_days(datetime.date(2020,7,17),s,Holiday)) year_0, month_0, day_0 = ago_Ybd_0.strftime("%Y-%b-%d").split("-") month_0 = month_0.upper() #import / unzip/ read file !wget 'https://www.ukp.com/content/historical/{year_0}/{month_0}/cm{day_0} {month_0}{year_0}kp.csv.zip' !unzip 'uk{day_0}{month_0}{year_0}kp.csv.zip' a_0=f'uk{day_0}{month_0}{year_0}kp.csv.zip' # problem area c=f'uk{day_0}{month_0}{year_0}' c = pd.read_csv(a_0,engine='python') # merge eod_a=c.merge(c,on='SYSTEM',how='left')
1 回答
慕蓋茨4494581
TA貢獻(xiàn)1850條經(jīng)驗(yàn) 獲得超11個(gè)贊
考慮構(gòu)建一個(gè)數(shù)據(jù)框列表，然后調(diào)用concat水平合并：
def get_data(s):
# a func which returns historical business dates
ago_Ybd_0 = (date_by_adding_business_days(datetime.date(2020, 7, 17), s, Holiday))
year_0, month_0, day_0 = ago_Ybd_0.strftime("%Y-%b-%d").split("-")
month_0 = month_0.upper()
#import / unzip/ read file
!wget
'https://www.ukp.com/content/historical/{year_0}/{month_0}/cm{day_0}
{month_0}{year_0}kp.csv.zip'
!unzip 'uk{day_0}{month_0}{year_0}kp.csv.zip'
a_0=f'uk{day_0}{month_0}{year_0}kp.csv.zip'
# RETURN DATA FRAME, SETTING SYSTEM AS INDEX
return pd.read_csv(a_0, engine='python', index_col='SYSTEM')
# BUILD LIST OF DFs VIA LIST COMPREHENSION
df_list = [get_data(s) for s in range(40)]
# BIND ALL DFs BY COLUMNS INTO SINGLE DF
final_df = pd.concat(df_list, axis='columns')
添加回答
舉報(bào)
0/150
提交
取消