problem with reading a csv file with pandas in executable

Question

i'm writing a software that reads a csv file at after some steps creates another csv file as output, the software is working fine but when i try to create an executable with pyinstaller i have an error saying that my software can't find the input csv file. Here is how i am reading the csv file as input, i've also tryed to change the pathname with no luck:

import pandas as pd
def lettore(): 
  RawData = pd.read_csv('rawdata.csv', sep=';')
return RawData

how can i solve the problem?

have you tried using the full path instead of the relative path? full path being c:\username\folder\file.csv? — MattR
– MattR, Commented Mar 9, 2020 at 17:55
i'd like not to use the full path because i have to use this software in different computers and the path of my csv file could change it is better that it could read it from the same folder where the executable is — lorenzo
– lorenzo, Commented Mar 9, 2020 at 18:00
Go ahead and play around with this, maybe print it even: basedir = os.path.dirname(sys.argv[0]) — Aiyion.Prime
– Aiyion.Prime, Commented Mar 9, 2020 at 18:27

ionpoint · Accepted Answer · 2020-03-09 18:15:58Z

1

Your code searches for the file it the same folder where the exe is launched.

It is equivalent to

import os
import pandas 

filepath = os.path.join(os.getcwd(), 'filename.csv')
df = pd.read_csv(filepath)

Do not use relative paths when you create an exe.

I can give you two other options:

Use an input to get the right file path when running the exe (or eventually use argparse).

filepath = input("insert your csv: ")
df = pd.read_csv(filepath)

Define an absolute path and build it in your code (you cannot change it after building and the program will read the file only from that path).

Edit: after reading your comment, see also

How to reliably open a file in the same directory as a Python script

edited Mar 9, 2020 at 18:15

answered Mar 9, 2020 at 18:04

ionpoint

8816 silver badges11 bronze badges

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

4 Comments

lorenzo Over a year ago

I tried to print the os.getcwd() output and it seems that my executable is running outside the folder where it is (i'm on mac) it is running in /Users/user insetad of in /Users/user/desktop/correctfolder

ionpoint Over a year ago

Are you executing the exe from that folder? Or are you running it from shell? Did you try it on windows?

ionpoint Over a year ago

Is your exe composed by multiple files/folder? Or just one?

lorenzo Over a year ago

just one but more .py files

Collectives™ on Stack Overflow

problem with reading a csv file with pandas in executable

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related