Notion2Pandas
Notion2Pandas is a Python 3 package that extends the capabilities of the excellent notion-sdk-py by Ramnes. It enables the seamless import of a Notion database into a pandas dataframe and vice versa, requiring just a single line of code.
Installation
pip install notion2pandas
Quick Start
Synchronous Client
from notion2pandas import Notion2PandasClient
import os
# Create client
n2p = Notion2PandasClient(auth=os.environ["NOTION_TOKEN"])
# Import database to NotionDataFrame
ndf = n2p.get_dataframe(os.environ["DATABASE_ID"])
# Work with your data
ndf.loc[ndf['Status'] == 'Todo', 'Status'] = 'In Progress'
# Save changes back to Notion
n2p.sync_to_notion(ndf)
Asynchronous Client
from notion2pandas import AsyncNotion2PandasClient
import os
# Create async client
async_n2p = AsyncNotion2PandasClient(auth=os.environ["NOTION_TOKEN"])
# Import database to NotionDataFrame (concurrent processing)
ndf = await async_n2p.get_dataframe(os.environ["DATABASE_ID"])
# Work with your data
ndf.loc[ndf['Status'] == 'Todo', 'Status'] = 'In Progress'
# Save changes back to Notion (concurrent updates)
await async_n2p.sync_to_notion(ndf)
For more complete, real-world examples, see the examples folder.
📖 Documentation
This README covers the basics. For everything else — filters and sorts, data sources, templates, callbacks, custom read/write functions, logging, and more — see the full documentation.
Migrating from v1.x
Version 2.0 introduces several improvements and breaking changes. If you're upgrading from v1.x:
| v1.x | v2.0 |
|---|---|
from_notion_DB_to_dataframe() |
get_dataframe() |
update_notion_DB_from_dataframe() |
sync_to_notion() |
from_notion_database_to_dataframes() |
get_dataframes() |
delete_rows_and_pages() |
delete_pages() |
Returns pd.DataFrame |
Returns NotionDataFrame |
PageID column |
page_id index |
| Manual row appending | ndf.add_page() |
📖 Complete migration guide with examples: MIGRATION-GUIDE.md
📚 v1.x documentation: README-v1.md
All v1.x methods still work with deprecation warnings - you have time to migrate!
Roadmap
Planned features for upcoming releases:
- DataFrame with property keys as column names: an option to get the DataFrame back with Notion's internal property keys as column names instead of their display names. More cumbersome to read, but immune to column renames in Notion, so your code doesn't break when someone renames a property on the Notion side.
Examples
Real-world scripts covering common use cases are available in the examples folder.
Changelog
View the complete version history on the changelog page.
Support
Notion2Pandas is an open-source project. Contributions are welcome!
- Report Issues: Found a bug? Open an issue
- Propose Changes: Have an improvement? Submit a merge request
- Fork the Project: Disagree with the direction? You're free to fork with our blessing!
All proposals will be evaluated and responded to.
License
This project is open-source and available under the MIT License.
1 maintainer
Metadata
1 maintainer
Release files for notion2pandas 3.0.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| notion2pandas-3.0.1.tar.gz | 2.0 MB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| notion2pandas-3.0.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 2.0 MB
Release files / notion2pandas-3.0.1.tar.gz
| Download URL | notion2pandas-3.0.1.tar.gz |
|---|---|
| Size | 2.0 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
af81f92028944ce2ecb0a0c9805858623fbb8442b56367bfa33829814fc676f4
|
|
BLAKE2b-256 checksum How to use checksums |
ede07f7deb9a0a1941f217eb3f8f5c4352b81340204cbcb797ca958f45a070d0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.12.12
|
Release files / notion2pandas-3.0.1-py3-none-any.whl
| Download URL | notion2pandas-3.0.1-py3-none-any.whl |
|---|---|
| Size | 37.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
9bb6fac9631c2d4baba086a37101962cec93b43373290fece55f45a648308583
|
|
BLAKE2b-256 checksum How to use checksums |
830cb2ea6b1a66ceabea1c73d383078b1b6fbcc1d7d7fa15515d5a922a512209
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.12.12
|
