unable to create excel data using pandas python

Question

I'm trying to create an excel file and try to open it and perform some operations on that data.

file_path = 'd:/files/'
file_folder = 'new_files'
file_name = 'sample.xlsx'

def export(data):
    data.to_excel("{}/{}".format(downloadpath(), downloadfile()), index=False)
    excel_data = open("{}/{}".format(downloadpath(), downloadfile()), 'rb')
    # excel_data_operations

def downloadpath():
     PATH = os.path.join(file_path, file_folder)

     if not os.path.isdir(PATH):
         return os.makedirs(PATH)
    
     return PATH

def downloadfile():
    return file_name

I'm trying to do this, but getting end up with

FileNotFoundError: [Errno 2] No such file or directory: 'None/sample.xlsx'

Laurent · Accepted Answer · 2021-03-31 15:41:11Z

1

In the definition of downloadpath:

replace return os.makedirs(PATH)
with os.makedirs(PATH)

answered Mar 31, 2021 at 15:41

Laurent

13.7k7 gold badges30 silver badges49 bronze badges

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

Comments

Dima Berehovets · Accepted Answer · 2021-03-31 15:35:02Z

0

The string 'd:/files/' says that you use windows. In windows, the file path should use backslashes '\'. Try to change the string to d:\files\

answered Mar 31, 2021 at 15:35

Dima Berehovets

2502 silver badges5 bronze badges

3 Comments

astroboy1 Over a year ago

I don't think its a / problem.

Dima Berehovets Over a year ago

You return os.makedirs(PATH). This function returns None. This is definitely the problem

Dima Berehovets Over a year ago

just remove 'return' before the 'os.makedirs(PATH)'

Collectives™ on Stack Overflow

unable to create excel data using pandas python

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related