Pandas — Import and Export Data from Excel & CSV files.

Python Pandas is a versatile library that finds numerous applications to the world of data analytics. Apart from a plethora of in-built functions, it provides an easy and efficient way to connect with a number of data sources.

In this post, we discuss how to import a csv and excel file from your local system into a Pandas data frame, and export data out from python (in this case Jupyter) environment to a csv file on your local system.

Let’s get started !

Import Data from a CSV File

Import Data from an excel Sheet

Export Data Frame as a CSV file to a specified folder on your local machine

Export Data Frame as an excel file to a specified folder on your local machine

Python provides means of connecting to a database, scraping web (Beautiful Soup), importing data from html files, and the fun part — it is all as easy as above !