Answers for "convert .data to .csv"

3

how to save a dataframe into an csv file

df.to_csv('file_name.csv', index=False)
Posted by: Guest on September-16-2020
11

save dataframe to csv

df.to_csv(file_name, sep='\t')
Posted by: Guest on May-07-2020
0

python convert dat file to csv

import csv

with open("infile.dat") as infile, open("outfile.csv", "w") as outfile:
    csv_writer = csv.writer(outfile)
    prev = ''
    csv_writer.writerow(['ID', 'PARENT_ID'])
    for line in infile.read().splitlines():
        csv_writer.writerow([line, prev])
        prev = line
Posted by: Guest on June-25-2020
1

df to csv

>>> df = pd.DataFrame({'name': ['Raphael', 'Donatello'],
...                    'mask': ['red', 'purple'],
...                    'weapon': ['sai', 'bo staff']})
>>> df.to_csv(index=False)
Posted by: Guest on February-07-2021
0

convert csv to pandas dataframe

import pandas as pd
df = pd.read_csv("sample_data.csv")

# .csv file format
column1,column2
1,2
3,4
5,6

# pandas dataframe
   column1  column2
0        1        2
1        3        4
2        5        6
Posted by: Guest on June-29-2020

Python Answers by Framework

Browse Popular Code Answers by Language