World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITian's, only for AI Learners.
Download our e-book of Introduction To Python
Related Blog
Top Discussion
about installing the softwere Exception Type: JSONDecodeError at /update/ Exception Value: Expecting value: line 1 column 1 (char 0) How to leave/exit/deactivate a Python virtualenvironment What is the difference between covariance and correlation? TypeError: 'int' object is not subscriptable Which are different modes to open a file ? How to handle imbalanced data and achieve good performance? What does it mean to cross-validate a machine learning model? Join Discussion
Top Courses
Machine Learning with Python & Statistics
4 (4,001 Ratings)
218 Learners
Webinars
Handling Different Data File In Python
Shashank Shanu
6 months ago
Table of Content
- Handling CSV Files
- Handling Text Files
- Handling excel file
- Conclusion
This article is a basic introduction to get some idea about how to import different
data into python. So, let’s start.
Python
provides us with many different functions to handle various types of data files.
In this article, I will try to take you through some of the functions mostly
used to handle different data files such as flat files, CSV and text, etc.
Handling CSV Files
One
of the most commonly used data file types is a CSV data file. CSV stands for
comma-separated-values. This type of file store data into a table from where
rows as observations and columns as attributes.
Let’s
take an example
import pandas as pd
data = pd.read_csv("People Charm case.csv")
print(data.shape)
data.head(5)
In
the above example, we used python library pandas which have a function “read_csv()”
to read a CSV file. Then we print the shape of the dataset and displayed only
the top 5 rows of the dataset using the head() function.
Output:
Handling Text Files
One
another most common flat file type is text files. Here we will take a file
that contains details of weblog in the text data file.
data2 = pd.read_table("file4.txt")
print(data2)In
the above example, we are reading a text file using pandas “read_table()”
function and printing it out.
Output:
Handling excel file
We
all know how popular and important excel file is and most of us used it in our
day to day life. So, it does not need any detailed introduction.
Let’s
take an example and see how we can read an excel file into python
data2 = pd.read_excel(“article topics.xlsx”)
data2.head()Output:
Here
we have an excel sheet and load it into python using “read_excel”
function available in panda’s library.
Conclusion
In
this, we learned about how to import different types of the data file into python.
Note I was using Jupiter notebook here so the output looks like this. The
knowledge of predictive modelling is important but equally important is knowing
how to import data files such as CSV, text, Excel files from a local machine
into the Python environment.
I hope you enjoyed reading this article and finally, you came
to know about Handling Different Data File In Python.
For more such blogs/courses on data science, machine
learning, artificial intelligence and emerging new technologies do visit us at InsideAIML.
Thanks for reading…
Happy Learning…