A library to fetch SharePoint list data and return it as a Pandas DataFrame.
Project description
SharePoint to DataFrame
A Python library to fetch data from a SharePoint list and return it as a Pandas DataFrame.
Installation
You can install the package using pip:
pip install sharepoint_to_df
Usage
Here is a simple example of how to use the library:
import pandas as pd
from sharepoint_to_df import sharepoint_utils
# Define your SharePoint credentials and site
username = 'your_username'
password = 'your_password'
sharepoint_site = 'https://yourtenant.sharepoint.com/sites/yoursite'
list_name = 'Your List Name'
# Fetch the data from the SharePoint list
df = sharepoint_utils.get_list_view_test(username, password, sharepoint_site, list_name)
# Display the DataFrame
print(df.head())
Parameters
username
(str): Your SharePoint username.password
(str): Your SharePoint password.sharepoint_site
(str): URL of your SharePoint site.list_name
(str): Name of the SharePoint list.view_name
(str, optional): Name of the SharePoint view. Default is "All Items".
Requirements
pandas
office365-rest-python-client
You can install the required dependencies using:
pip install pandas office365-rest-python-client
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sharepoint_to_df-0.5.0.tar.gz
(2.6 kB
view hashes)
Built Distribution
Close
Hashes for sharepoint_to_df-0.5.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 60c35466a6c971e51d821485072c325ca9c7b2b9684a9c9c680aebc98b5befbe |
|
MD5 | f00d980c90d58860693ce6e316d2f328 |
|
BLAKE2b-256 | bf68674c5814a65747eb7272beb62780cc8fb490668012ead231b72b56783144 |