python—尝试根据从CSV读取的变量创建一系列列

p4tfgftt  于 2021-09-08  发布在  Java
关注(0)|答案(1)|浏览(226)

显然,我对这一点很陌生。我想将每个变量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')
3qpi33ja

3qpi33ja1#

您是否尝试了join()方法?以下是文档:join()

相关问题