CSV File Handling with Python

 

from csv import reader

from csv import DictReader

from csv import writer

from csv import DictWriter

# Reading csv files
reader
with open("file.csv") as f1:
    csv_file = reader(f1)
    for data in csv_file:
        print(data)
# DictReader
with open("file.csv") as f2:
    my_csv = DictReader(f2, delimiter="#")
    for i in my_csv:
        print(i)
# Writing csv files
# writer
with open("My_csv.csv","w",newline="") as f3:
    write_csv = writer(f3)
#     # writerow
    write_csv.writerow(["first_name","last_name","age"])
    write_csv.writerow(["Adrika","Bhadauria","14"])
    write_csv.writerow(["Anika","Singh","3"])
    # writerows
    write_csv.writerows([["first_name","last_name","age"],

                                        ["Adrika","Bhadauria","14"],

                                        ["Anika","Singh","3"]])
# DictWriter
with open("learn_csv.csv","w",newline="") as f4:
    dict_write = DictWriter(f4,fieldnames=["first_name","last_name","age"])
    dict_write.writeheader()
    # writerow
    dict_write.writerow({"first_name":"Adrika",
                                      "last_name":"Bhadauria",
                                      "age":14})
    dict_write.writerow({"first_name":"Anika",
                                      "last_name":"Singh",
                                      "age":3})
    # writerows
    dict_write.writerows([
        {"first_name":"Adrika","last_name":"Bhadauria","age":14},
        {"first_name":"Anika","last_name":"Singh","age":3}
    ])