Csv in python

Csv python write

import csv

with open('names.csv', 'w') as csvfile:
    fieldnames = ['first_name', 'last_name']
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)

    writer.writeheader()
    writer.writerow({'first_name': 'Baked', 'last_name': 'Beans'})
    writer.writerow({'first_name': 'Lovely', 'last_name': 'Spam'})
    writer.writerow({'first_name': 'Wonderful', 'last_name': 'Spam'})

Source: docs.python.org

Python csv reader

with open(r'c:\dl\FrameRecentSessions.csv') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    line_count = 0
    for row in csv_reader:
        if line_count == 0:
            print(f'Column names are {", ".join(row)}')
            line_count += 1
        else:
            print(f'\t{row[0]} works in the {row[1]} department, and was born in {row[2]}.')
            line_count += 1
    print(f'Processed {line_count} lines.')

How to open csv file in python

import csv

with open('example.csv') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',')

How to open csv file in python

import pandas as pd # pip install pandas

#read the CSV file
data_file = =pd.read_csv('some_file.csv')
print(data_file)

Python csv

>>> import csv
>>> with open('names.csv', newline='') as csvfile:
...     reader = csv.DictReader(csvfile)
...     for row in reader:
...         print(row['first_name'], row['last_name'])
...
Eric Idle
John Cleese

>>> print(row)
{'first_name': 'John', 'last_name': 'Cleese'}

Source: docs.python.org

Csv in python

import csv
csv.register_dialect('unixpwd', delimiter=':', quoting=csv.QUOTE_NONE)
with open('passwd', newline='') as f:
    reader = csv.reader(f, 'unixpwd')

Source: docs.python.org

Similar codes

1 vote322 views1 answer
Directly changing the fonts in the plotting file
Python
2 votes320 views1 answer
Python 3.7 tutorial pdf with exercises
Python
22 votes356 views6 answers
Python numpy array to list
Python
1 vote338 views1 answer
Pytorch summary model
Python
2 votes324 views5 answers
Pandas rename single column
Python
0 vote335 views1 answer
Python list to sublists
Python
0 vote335 views1 answer
Rotate image pyqt5
Python
59 votes343 views6 answers
Python replace character in string
Python
17 votes350 views3 answers
Create log in python
Python
19 votes316 views1 answer
Python left string
Python