Question

1. In Python, Create a CSV file that has 10 items with topic headers that are separated by commas.

Example: a,b,c,d,total

1,2,3,4,number

2. Use the Python pandas function to read the CSV file into a Dataframe. Provide a screenshot or the actual output.

Answer 1

Below is the answer:

Explanation:

import pandas as pd

ProjectPath = os.getcwd()

filename = "TestFile.csv"

MyPath = ProjectPath + '\\' + filename

data_df = pd.read_csv(MyPath)

print(data_df)

Python Output

>>>

RESTART: E:\CDAC_31_12_2017_Backup\CheggIndia_Anshu_Office\PythonCode\CheggPython.py

<_csv.reader object at 0x0605A630>

>>>

RESTART: E:\CDAC_31_12_2017_Backup\CheggIndia_Anshu_Office\PythonCode\CheggPython.py

  a  b  c  d  total

0  1  2  3  4  number

1  u  v  w  x letters

2 10 20 30 40  prices

3  a  b  c  d  total

4  1  2  3  4  number

5  u  v  w  x letters

6 10 20 30 40  prices

7  u  v  w  x letters

8 10 20 30 40  prices

>>>