With this post, we will learn how to perform read and write operations on different formats of data.
Note:- For examples here, I have stored the files like csv and excel in the same folder where the codes are written or where the jupyter notebook file is. If you want, you can download the same files as i have used here, from my github repo.
1) CSV- comma separated values
A comma separated values (CSV) file is a text file that has a specific format that allows data to be saved in a table structured format.
(Advice:- It’s always good to know at least basics of NumPy/ Matplotlib before jumping to Pandas)
What is Pandas?
Pandas is an open source, BSD-licensed library which provides easy to use data structures, data analysis, data manipulation tools for the python programming language. It’s built on top of two core libraries of Python — matplotlib (used for data visualization) and NumPy (used for mathematical Operations).
Pandas is like excel of Python. Data Frame is analogous to a table and Series is…
Data Science Enthusiast | Full Stack Web Developer( MERN) | Flask | DevOps