Third-party I/O libraries

While pandas covers an impressive amount of formats it cannot hope to cover every important format out there. Third-party libraries exist to cover that gap.

Here are a few you may be interested in – the details of how they work are outside the scope of this book, but they all generally follow the pattern of having read functions that return pd.DataFrame objects and write methods that accept a pd.DataFrame argument:

• pandas-gbq allows you to exchange data with Google BigQuery
• AWS SDK for pandas works with Redshift and the AWS ecosystem at large
• Snowflake Connector for Python helps exchange with Snowflake databases
• pantab lets you move pd.DataFrame objects in and out of Tableau’s Hyper database format (note: I am also the author of pantab)

Join our community on Discord

Join our community’s Discord space for discussions with the authors and other readers:

https://packt.link/pandas

...