Data Science – First Step with Python and Pandas (Read CSV File)

Hi, Folks hope you all are doing awesome, So today I’m going to start Data analysis with Python Pandas. this tutorial is all about the Basics of Data analysis. we are going to read CSV file with the help of Pandas library.

Pandas is one of the most popular Python libraries for Data Science and Analytics. I like to say it’s the “SQL of Python.” Why? Because pandas help you to manage two-dimensional data tables in Python. Of course, it has many more features. In this pandas tutorial series, I’ll show you the most important things that you have to know as an Analyst or a Data Scientist.

I assume that you already install Python in your System, So I’m going to start directly with Pandas. In order to use pandas, we need an IDE you can use PyCharm or Jupyter notebook either one of them.

• PyCharm
• Jupyter NoteBook 

In order to run the Pandas Code, we have to import the Pandas Library to support all its features.

import pandas as pd

“pd” works as an alias to access the panda’s libraries. Now Pandas is ready to execute the essential code

In the second step, we have to define a variable which holds the data of CSV file and that variable we called data frame.

df = pd.read_csv("D:\employee.csv")

pd  refer the Pandas library to read CSV file and inside it, we call the file location.

"D:\employee.csv"

After that, we are going to display that our code is working or not and for that part, we are going to use head() function. Head function print 5 first value as the default mode.

df.head()

df is our data frame, so we called data from CSV file with pandas.

All code Together

import pandas as pd
df = pd.read_csv("D:\employee.csv")
df.head()

Output

	ID	Name	Department
0	1	Rohan	IT
1	2	Mohan	HR
2	3	Ram	Marketing
3	4	Abhishek	IT
4	5	Jamaley	IT

If you want to sort the data by the department with Pandas then it is very easy. just add index_col=’Department’ after your file location.

df = pd.read_csv("D:\employee.csv", index_col='Department')

Here is the sorted data.

ID	Name
Department		
IT	1	Rohan
HR	2	Mohan
Marketing	3	Ram
IT	4	Abhishek
IT	5	Jamaley

Here are the Screenshots : –

Before sorting the data

After sorting the data with index_col

Check Python Python Libraries for Data Science

Top 4 Python Libraries for Data Science in 2018

I hope this post helped you to know Data Science – First Step with Python and Pandas (Read CSV File). To get the latest news and updates follow us on twitter & facebook, subscribe to our YouTube channel.  And If you have any query then please let us know by using the comment form.

Related posts:

Creating Pivot Table with Pandas Data Cleaning with Pandas Python : Missing Values Top 4 Python Libraries for Data Science in 2018 Flatten list item from Column – Python [Data Cleaning]