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 get_list_view_test
# 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 = 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.3.1.tar.gz
(2.2 kB
view hashes)
Built Distribution
Close
Hashes for sharepoint_to_df-0.3.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c3d1eda3d41a6562af1d7eddec58181e58c7ed9412dc6b48884c4b18a1f2829a |
|
MD5 | 171ba0c76c2ffeca60b4a34cfb7061fb |
|
BLAKE2b-256 | 35171b3c45a7f72ca2ca94e535ac75fb7213f6326cf29808214a387f39d213d0 |