显然,我对这一点很陌生。我想将每个变量t、dell_gh、em_gh、lambs_gh、mc_gh和par_gh组织到一个表中,以便将它们导出为csv。现在我想我只是在gh中创建一个所有变量的列表,而不是我想要的一系列列。我真的不知道正确的格式来创建这个,我也不知道如何在谷歌上正确地问这个问题
import pandas as pd
"importing data"
Dell = pd.read_csv('Dell_24hr.dat', sep = ',' , skiprows = 3)
Em = pd.read_csv('Emigration_24hr.dat', sep = ',' , skiprows = 3)
Lambs = pd.read_csv('Lambs_24hr.dat', sep = ',' , skiprows = 3)
MC = pd.read_csv('Millcreek_24hr.dat', sep = ',' , skiprows = 3)
Par = pd.read_csv('Parleys_24hr.dat', sep = ',' , skiprows = 3)
"Separate variables"
T = Dell.iloc[:, 0:1]
T.columns = ['Date']
Dell_gh = Dell.iloc[:, 2:3]
Dell_gh.columns = ['Dell Gauge Height']
Em_gh = Em.iloc[:, 2:3]
Em_gh.columns = ['Emigration Gauge Height']
Lambs_gh = Lambs.iloc[:, 2:3]
Lambs_gh.columns = ['Lambs Gauge Height']
MC_gh = MC.iloc[:, 2:3]
MC_gh.columns = ['Millcreek Gauge Height']
Par_gh = Par.iloc[:, 2:3]
Par_gh.columns = [' Parleys Gauge Height']
gh = (Dell_gh, Em_gh, Lambs_gh, MC_gh, Par_gh)
"calculate CFS"
# CFS.columns = ['CFS']
print(gh)
gh.to_csv('test gauge.csv')
1条答案
按热度按时间3qpi33ja1#
您是否尝试了join()方法?以下是文档:join()