How to Read CSV in Python Where it Differs Normal File

Here is a way to read CSV files in a python program. To do this, you need to import NumPy and Pandas. With these, you can read CSV files.

For Text files, you don't need to import special libraries. By default, python supports it.

CSV and Text Files

Reading CSV files

>>> import numpy as np
>>> import pandas as pd

To see how pandas handle this kind of data, we'll create a small CSV file in the working directory as ch05_01.csv.

white, red, blue, green, animal

Since this file is comma-delimited, you can use the read_csv() function to read its content and convert it to a dataframe object.
>>> csvframe = pd.read_csv('ch05_01.csv')
>>> csvframe
   white  red  blue  green animal
0      1    5     2      3    cat
1      2    7     8      5    dog
2      3    3     6      7  horse
3      2    2     8      3   duck
4      4    4     2      1  mouse

Reading normal files

Since python supports text files, you don't need to import NumPy and Pandas. The syntax is a little different. 

Using the Open method, here file is opened with read mode. In the place file name, it has given; the full path of the file. The Print method displays contents. Here read method is used to read the file.

# Open our file in read mode 
f = open("data/flatland01.txt", mode="r") 
# Read and display the text file 
# Close our file resource 

Finally, working with CSV and Text files knowing is helpful for interviews.


Post a Comment

Thanks for your message. We will get back you.

Previous Post Next Post