© A.J. Henley and Dave Wolf 2018
A.J. Henley and Dave WolfLearn Data Analysis with Pythonhttps://doi.org/10.1007/978-1-4842-3486-0_2

2. Getting Data Into and Out of Python

A. J. Henley1  and Dave Wolf2
Washington, D.C., District of Columbia, USA
Sterling Business Advantage, LLC, Adamstown, Maryland, USA

The first stage of data analysis is getting the data. Moving your data from where you have it stored into your analytical tools and back out again can be a difficult task if you don't know what you are doing. Python and its libraries try to make it as easy as possible.

With just a few lines of code, you will be able to import and export data in the following formats:
  • CSV

  • Excel

  • SQL

Loading Data from CSV Files

Normally, data will come to us as files ...

Get Learn Data Analysis with Python: Lessons in Coding now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.