6. Importing and Exporting Data
By the end of this chapter, you will be able to:
- Use psql at the command line to efficiently interact with your database
- Use the COPY command to upload data to your database in bulk
- Use Excel to process data from your database
- Simplify your code using SQLAlchemy in Python
- Upload and download data to and from your database in bulk with R and Python
This chapter covers how to move data between your database and other analytics processing pipelines.