import data in python using pandas

Question

This is the code that I used to import my data as csv

from pandas import read_csv
from matplotlib import pyplot as pltplt
series = read_csv('final.csv', header=0, index_col=0)

this is the second one which I tried

import csv
with open('people.csv', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        print(row)

But I found same kind of error like this in both case

FileNotFoundError: [Errno 2] File final.csv does not exist: 'final.csv'

As the error says: FileNotFoundError: File final.csv does not exist. The code cannot find the file you've tried to open. Is the file in the same folder that you're launching the script from? — Hampus Larsson
– Hampus Larsson, Commented Nov 16, 2020 at 20:01
Does this answer your question? Pandas can't open a csv file FileNotFoundError — Yuca
– Yuca, Commented Nov 16, 2020 at 20:20

Maximilian Freitag · Accepted Answer · 2020-11-16 20:36:54Z

1

You could do following:

import pandas as pd
df = pd.read_csv("./Path/where/you/stored/table/data.csv")
print(df)

(df stands for data file)

File final.csv does not exist:

The error that you make is that you don't type in the correct path where the csv is stored. Are you using jupyter?

answered Nov 16, 2020 at 20:36

1,0493 gold badges15 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thank you, this code really helped me to import my data set.

marouane youssfi · Accepted Answer · 2020-11-16 20:14:03Z

0

add the folder csv like with open('c:\\Users\\admin\\ ..... .csv', 'r') as file:

answered Nov 16, 2020 at 20:14

marouane youssfi

394 bronze badges