CSV 文件无法使用熊猫打开

Question

#Directory change
import os
os.chdir('D:\Scripts\Visual Studio Code\money_outflow')
print('Current directory:', os.getcwd())
#Importing pandas as pd
import pandas as pd 
#Reading account.csv
accountData = pd.read_csv("account.csv")
accountData.head()
#User input
date = input('Enter today''s date: ')
amount = float(input('Enter the amount: '))
#Appending input
user_input = pd.DataFrame({'Date': [date],
'Amount Spent': [amount]})
accountData.append(user_input, ignore_index=True)

你好!我已尝试在其中包含数据的文件上运行此代码。但是，命令'accountData.head()'不会呈现任何内容。你能帮我一下吗?

Answer 1

需要一个print语句

print(accountData.head())

Answer 2

使用display命令查看输出。因此,使用:

display (accountData.head())

和

display(accountData.append(user_input, ignore_index=True))

Answer 3

Try by csv bro(从第一行获取数据):

import csv
data = []
with open('wss/wss.csv', "r") as csvDataFile:
csvReader = csv.reader(csvDataFile)
for row in csvReader:
data.append(row[0])
print (data[1])
print (data[2])

对我来说csv更简单;)