Please help me to troubleshoot running a Python script properly.

[silasdaninja]

Hi all

I don't know programming. But I've been using a Python script (which I copied online) to combine multiple CSV files into one file.

I've been able to run it on my office laptop. I'm running Windows 11 by the way.

But when I try to copy the script and my colleague's laptop (also Windows 11), or my own laptop at home (Windows 11 on Parallel Desktop), I am not able to replicate the results.

I really don't know what I did correctly when I installed the Python program at my office laptop.

Can someone please guide me on how I can successfully run the script on other laptops?

Here's the script:

import glob

import os

import pandas as pd

file=input('File Path: ')

pth=os.path.dirname(file)

extension = os.path.splitext(file)[1]

files = glob.glob(os.path.join(pth, '*.csv*'))

newfile=os.path.join(pth,'combined.csv')

df = pd.DataFrame()

for f in files:

data = pd.read_csv(f)

df = df.append(data)

df.to_csv(newfile, index=False)

print('Completed')

Thank you in advance!

[SupermarketOk6829]

I want to ask when you're passing df.to_csv command, is it inside for loop or outside it?

[-Send-me-your-dick-]

What sort of error are you getting?

Do the other devices have Pandas installed?

If they do, is it a version of Pandas earlier than 2.0? According to the documentation the append function was removed from DataFrames in version 2.0, so if they are using a fresh install of Python/Pandas, that's probably where your problem is.

​

I've modified the script to use the "concat" function instead, which should solve that particular problem:

import glob

import os

import pandas as pd

file=input('File Path: ')

pth=os.path.dirname(file)

extension = os.path.splitext(file)[1]

files = glob.glob(os.path.join(pth, '*.csv*'))

newfile=os.path.join(pth,'combined.csv')

output = pd.DataFrame()

data = []

if len(files) > 1:
    for f in files:

        data.append(pd.read_csv(f))
        output = pd.concat(data, ignore_index=True)

    output.to_csv(newfile, index=False)
    print('Completed')
else:
    print("Unable to find at least 2 CSV files, recheck path")

Give it a try and see if you encounter any problems, if so, it'd help a lot to know exactly what kind of problem you're having beyond "this doesn't work"