Breaking News: Grepper is joining You.com. Read the official announcement!

pandas continues update csv

Worried Walrus answered on August 18, 2021 Popularity 5/10 Helpfulness 1/10

answer pandas continues update csv

related pandas continues update csv

pandas continues update csv

Comment

In [1]: df = pd.read_csv('foo.csv', index_col=0)

In [2]: df
Out[2]:
   A  B  C
0  1  2  3
1  4  5  6

In [3]: df + 6
Out[3]:
    A   B   C
0   7   8   9
1  10  11  12

In [4]: with open('foo.csv', 'a') as f:
             (df + 6).to_csv(f, header=False)

Popularity 5/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: csv pandas python

Link to this answer
Share Copy Link

Contributed on Aug 18 2021

Worried Walrus

0 Answers Avg Quality 2/10

Closely Related Answers

pandas continues update csv

Comment

def appendDFToCSV_void(df, csvFilePath, sep=","):
    import os
    if not os.path.isfile(csvFilePath):
        df.to_csv(csvFilePath, mode='a', index=False, sep=sep)
    elif len(df.columns) != len(pd.read_csv(csvFilePath, nrows=1, sep=sep).columns):
        raise Exception("Columns do not match!! Dataframe has " + str(len(df.columns)) + " columns. CSV file has " + str(len(pd.read_csv(csvFilePath, nrows=1, sep=sep).columns)) + " columns.")
    elif not (df.columns == pd.read_csv(csvFilePath, nrows=1, sep=sep).columns).all():
        raise Exception("Columns and column order of dataframe and csv file do not match!!")
    else:
        df.to_csv(csvFilePath, mode='a', index=False, sep=sep, header=False)

Popularity 6/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: pandas python csv exception panda

Link to this answer
Share Copy Link

Contributed on Aug 18 2021

Worried Walrus

0 Answers Avg Quality 2/10

pandas continues update csv

Contents

More Related Answers

pandas continues update csv

Closely Related Answers

pandas continues update csv

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.