用新行读取CSV文件

Question

我想读取我创建的 CSV 文件，并将其打印在新行上：

代码

rows = []
with open("test.csv", 'r') as file:
    csvreader = csv.reader(file)
    header = next(csvreader)
    for row in csvreader:
        rows.append(row)
print(header)
print(rows)

这是我得到的输出的

['TeamName', 'MCount']
[[], ['team One', '23'], ['Team Two', '102'], ['Team Three', '44'], ['Team Four', '40']]

是这样的...我希望它看起来像这样：

Team One 23    
Team Two 102    
Team Three 44    
Team Four 40

Answer 1

您可以在行上迭代并以所需的格式打印每一行：

# For each row
for row in rows:
    # Make sure the row is not empty
    if row:
        # Print the row
        print(row[0], row[1])

或者，您可以使用列表理解将其全部保存为一个字符串，以将其作为一个变量：

# For each row,
# if the row is not empty
# format it into a string.
# Join all the resulting strings together by a new line.
my_data_string = "\n".join([f"{row[0]} {row[1]}" for row in rows if row])

Answer 2

此方法将以您请求的格式打印，并对行进行编号。

import pandas as pd

data = pd.read_csv('test.csv', header = None, names = ['Team Name', 'Number', 'Score'])

print(data)

输出：

      Team Name  Number  Score
0     Team One       23    NaN
1     Team Two       102   NaN
2     Team Three     44    NaN
3     Team Four      40    NaN

Answer 3

现在还有最后一个问题；

这是输出：

'''

0 1 2

0 TeamName MCount Score

1 Team One 23 NaN

2 Team Two 234 NaN

3 Team Three 3 NaN

'''

上面的数字我不想要