如何连接到Azure文件共享并使用Python读取csv文件

zqdjd7g9 于 2023-08-07 发布在 Python

关注(0)|答案(1)|浏览(122)

我正在尝试编写Python代码来连接到Azure文件共享，其中URL带有一些凭据/密钥：
我正在从IDE（Visual Studio Code）运行此代码。
但是，我不知道怎么写URL信息。

from azure.storage.file import FileService

storageAccount='cocacola'
accountKey='xxxdrinksomethingxxxx'

file_service = FileService(account_name=storageAccount, account_key=accountKey)

share_name = 'dietcoke'
directory_name = 'test'
file_name = '20230728.csv'
file = file_service.get_file_to_text(share_name, directory_name, file_name)
print(file.content)

字符串
当前，错误消息为“azure.common.AzureMissingResourceHttpError：指定的父路径不存在。Error Code：ParentNotFound”
如何在这里添加URL信息代码？

Azure

来源：https://stackoverflow.com/questions/76791009/how-to-connect-to-azure-file-share-and-read-csv-file-using-python

1条答案

按热度按时间

58wvjzkj1#

当前，错误消息为“azure.common.AzureMissingResourceHttpError：指定的父路径不存在。Error Code：ParentNotFound”
当您没有在存储帐户中指定路径或目录时，会出现上述错误。
下面是我在存储帐户中的结构：

Storage account name = venkat123 
fileshare=fileshare1
directory=directory1
filename=day.csv

字符串

入口：

您可以使用以下代码读取带有帐户URL和密钥的CSV文件。
为此，您需要安装azure-storage-file-share包。

验证码：

from azure.storage.fileshare import ShareServiceClient, ShareClient, ShareDirectoryClient, ShareFileClient
import pandas as pd
import io

account_url = "https://venkat123.file.core.windows.net"
account_key = "xxxxxx"
service_client = ShareServiceClient(account_url=account_url, credential=account_key)
share_name = "fileshare1"
share_client = service_client.get_share_client(share_name)

# Get a ShareDirectoryClient object to connect to the directory
directory_path = "directory1"
directory_client = share_client.get_directory_client(directory_path)
file_name = "day.csv"
file_client = directory_client.get_file_client(file_name)

file_contents = file_client.download_file().readall()
csv_data = file_contents.decode('utf-8')
df = pd.read_csv(io.StringIO(csv_data))
print(df)

型

输出：

Numeric  Numeric-2 Numeric-Suffix
0         1          1            1st
1         2          2            2nd
2         3          3            3rd
3         4          4            4th
4         5          5            5th
5         6          6            6th
6         7          7            7th
7         8          8            8th
8         9          9            9th
9        10         10           10th
10       11         11           11th
11       12         12           12th
12       13         13           13th
13       14         14           14th
14       15         15           15th
15       16         16           16th
16       17         17           17th
17       18         18           18th
18       19         19           19th
19       20         20           20th
20       21         21           21st
21       22         22           22nd
22       23         23           23rd
23       24         24           24th
24       25         25           25th
25       26         26           26th
26       27         27           27th
27       28         28           28th
28       29         29           29th
29       30         30           30th
30       31         31           31st

型

的