dlwlrma dlwlrma - 3 years ago 117
Python Question

How to change a .csv file to .dat file using pandas?

For example, the csv file looks like this: csv content. How to change it to .dat file like this using '|':

a 1|b 2|c 3|d 4|...

a 2|b 3|c 4|d 5|...

a 3|b 4|c 5|d 6|...

...

Answer Source

Consider the dataframe df

df = pd.DataFrame([
    [1, 2, 3, 4],
    [2, 3, 4, 5],
    [3, 4, 5, 6]
], columns=list('abcd'))

   a  b  c  d
0  1  2  3  4
1  2  3  4  5
2  3  4  5  6

IIUC

df.astype(str).radd(
    df.columns.to_series() + ' '
).to_csv('test.data', header=None, index=None, sep='|')

cat test.data

a 1|b 2|c 3|d 4
a 2|b 3|c 4|d 5
a 3|b 4|c 5|d 6
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download