我正试图从我的私有谷歌硬盘读取CSV文件.该文件具有以下授权:任何具有链接的人.这是链接:https://drive.google.com/file/d/12txcYHcO8aiwO9f948_nsaIE3wBGAuJa/view?usp=sharing
以下是该文件的示例:
email first_name last_name
uno@gmail.com Luca Rossi
due@gmail.com Daniel Bianchi
tre@gmail.com Gabriel Domeneghetti
qua@gmail.com Christian Bona
cin@gmail.com Simone Marsango
我需要读取这个文件,以便将这些数据解析为一个程序.我try 了很多方法,例如在这个问题中提出的每种可能性:Pandas: How to read CSV file from google drive public?.
csv_file_url = 'the file URL as copied in the drive UI'
file_id = csv_file_url.split('/')[-2]
dwn_url = 'https://drive.google.com/uc?export=download&id=' + file_id
url2 = requests.get(dwn_url).text
csv_raw = StringIO(url2)
df = pd.read_csv(csv_raw)
print(df.head())
这应该行得通,但只返回这个表:
ÿþe Unnamed: 1 Unnamed: 2
0 NaN NaN NaN
1 NaN NaN NaN
2 NaN NaN NaN
3 NaN NaN NaN
4 NaN NaN NaN
我认为这只是一个格式问题,但我不知道如何摆脱它.如果你知道怎么做,请帮帮我.