How To Read CSV File In Python With Source Code

Posted by angel jude suarezPosted in Python Projects July 16, 2020

CSV_File_In_Python_With_Source_Code

How To Read CSV File In Python With Source Code

The Project How To Read A CSV File In Python is design in python programming language. Python is very smooth to research the syntax emphasizes readability and it is able to reduces time ingesting in developing.

A Reading CSV File In Python, Also design in Graphical User Interface (GUI), This article also includes the downloadable Read A CSV File In Python source code for free.

In this tutorial, I will teach you on How To Read A CSV File In Python, Also in this tutorial is the simplest way for the beginners or the student to Writing CSV File In Python .

Watch the video to see the running application of reading csv file in python.

To start ceating a CSV File In Python, make sure that you have Pycharm IDE installed in your computer.

By the way if you are new to python programming and you don’t know what would be the the Python IDE to use, I have here a list of Best Python IDE for Windows, Linux, Mac OS that will suit for you. I also have here How to Download and Install Latest Version of Python on Windows.

Steps on How To Read CSV File In Python With Source Code

How To Read CSV File In Python With Source Code

Step 1: Create a project name.
First, open Pycharm IDE and click “file” after that create a project name and then click “create” button.
Step 2: Create python file.
Second “right click” your project name folder and choose new and then click “python file“.
Step 3: Name your python file.
Third, name your python file and click “enter” to start creating CSV File In Python.
Step 4: The actual code.
Fourth, the actual coding in creating CSV File In Python, you are free to copy the code and download full source code given below.

The code given below is for Importing modules.

from tkinter import *
import tkinter.ttk as ttk
import csv

1

2

3

from tkinter import *

import tkinter.ttk as ttk

import csv

In this part of codes which is importing all the modules given on top.

The code given below is for the design of this project.

root = Tk()
root.title("Python - Import CSV File To Tkinter Table")
width = 500
height = 400
screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()
x = (screen_width/2) - (width/2)
y = (screen_height/2) - (height/2)
root.geometry("%dx%d+%d+%d" % (width, height, x, y))
root.resizable(0, 0)


TableMargin = Frame(root, width=500)
TableMargin.pack(side=TOP)
scrollbarx = Scrollbar(TableMargin, orient=HORIZONTAL)
scrollbary = Scrollbar(TableMargin, orient=VERTICAL)
tree = ttk.Treeview(TableMargin, columns=("Firstname", "Lastname", "Address"), height=400, selectmode="extended", yscrollcommand=scrollbary.set, xscrollcommand=scrollbarx.set)
scrollbary.config(command=tree.yview)
scrollbary.pack(side=RIGHT, fill=Y)
scrollbarx.config(command=tree.xview)
scrollbarx.pack(side=BOTTOM, fill=X)
tree.heading('Firstname', text="Firstname", anchor=W)
tree.heading('Lastname', text="Lastname", anchor=W)
tree.heading('Address', text="Address", anchor=W)
tree.column('#0', stretch=NO, minwidth=0, width=0)
tree.column('#1', stretch=NO, minwidth=0, width=200)
tree.column('#2', stretch=NO, minwidth=0, width=200)
tree.column('#3', stretch=NO, minwidth=0, width=300)
tree.pack()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

root = Tk()

root.title("Python - Import CSV File To Tkinter Table")

width = 500

height = 400

screen_width = root.winfo_screenwidth()

screen_height = root.winfo_screenheight()

x = (screen_width/2) - (width/2)

y = (screen_height/2) - (height/2)

root.geometry("%dx%d+%d+%d" % (width, height, x, y))

root.resizable(0, 0)

TableMargin = Frame(root, width=500)

TableMargin.pack(side=TOP)

scrollbarx = Scrollbar(TableMargin, orient=HORIZONTAL)

scrollbary = Scrollbar(TableMargin, orient=VERTICAL)

tree = ttk.Treeview(TableMargin, columns=("Firstname", "Lastname", "Address"), height=400, selectmode="extended", yscrollcommand=scrollbary.set, xscrollcommand=scrollbarx.set)

scrollbary.config(command=tree.yview)

scrollbary.pack(side=RIGHT, fill=Y)

scrollbarx.config(command=tree.xview)

scrollbarx.pack(side=BOTTOM, fill=X)

tree.heading('Firstname', text="Firstname", anchor=W)

tree.heading('Lastname', text="Lastname", anchor=W)

tree.heading('Address', text="Address", anchor=W)

tree.column('#0', stretch=NO, minwidth=0, width=0)

tree.column('#1', stretch=NO, minwidth=0, width=200)

tree.column('#2', stretch=NO, minwidth=0, width=200)

tree.column('#3', stretch=NO, minwidth=0, width=300)

tree.pack()

In this module which is the design of the project CSV File In Python.

The code given below is for reading the CSV file.

with open('test.csv') as f:
    reader = csv.DictReader(f, delimiter=',')
    for row in reader:
        firstname = row&#91;'firstname']
        lastname = row&#91;'lastname']
        address = row&#91;'address']
        tree.insert("", 0, values=(firstname, lastname, address))

1

2

3

4

5

6

7

with open('test.csv') as f:

reader = csv.DictReader(f, delimiter=',')

for row in reader:

firstname = row['firstname']

lastname = row['lastname']

address = row['address']

tree.insert("", 0, values=(firstname, lastname, address))

In this module which is reading the CSV file and displayed in tkinter table.

Complete Source Code

from tkinter import *
import tkinter.ttk as ttk
import csv

root = Tk()
root.title("Python - Import CSV File To Tkinter Table")
width = 500
height = 400
screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()
x = (screen_width/2) - (width/2)
y = (screen_height/2) - (height/2)
root.geometry("%dx%d+%d+%d" % (width, height, x, y))
root.resizable(0, 0)


TableMargin = Frame(root, width=500)
TableMargin.pack(side=TOP)
scrollbarx = Scrollbar(TableMargin, orient=HORIZONTAL)
scrollbary = Scrollbar(TableMargin, orient=VERTICAL)
tree = ttk.Treeview(TableMargin, columns=("Firstname", "Lastname", "Address"), height=400, selectmode="extended", yscrollcommand=scrollbary.set, xscrollcommand=scrollbarx.set)
scrollbary.config(command=tree.yview)
scrollbary.pack(side=RIGHT, fill=Y)
scrollbarx.config(command=tree.xview)
scrollbarx.pack(side=BOTTOM, fill=X)
tree.heading('Firstname', text="Firstname", anchor=W)
tree.heading('Lastname', text="Lastname", anchor=W)
tree.heading('Address', text="Address", anchor=W)
tree.column('#0', stretch=NO, minwidth=0, width=0)
tree.column('#1', stretch=NO, minwidth=0, width=200)
tree.column('#2', stretch=NO, minwidth=0, width=200)
tree.column('#3', stretch=NO, minwidth=0, width=300)
tree.pack()

with open('test.csv') as f:
    reader = csv.DictReader(f, delimiter=',')
    for row in reader:
        firstname = row&#91;'firstname']
        lastname = row&#91;'lastname']
        address = row&#91;'address']
        tree.insert("", 0, values=(firstname, lastname, address))

#============================INITIALIZATION==============================
if __name__ == '__main__':
    root.mainloop()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

from tkinter import *

import tkinter.ttk as ttk

import csv

root = Tk()

root.title("Python - Import CSV File To Tkinter Table")

width = 500

height = 400

screen_width = root.winfo_screenwidth()

screen_height = root.winfo_screenheight()

x = (screen_width/2) - (width/2)

y = (screen_height/2) - (height/2)

root.geometry("%dx%d+%d+%d" % (width, height, x, y))

root.resizable(0, 0)

TableMargin = Frame(root, width=500)

TableMargin.pack(side=TOP)

scrollbarx = Scrollbar(TableMargin, orient=HORIZONTAL)

scrollbary = Scrollbar(TableMargin, orient=VERTICAL)

tree = ttk.Treeview(TableMargin, columns=("Firstname", "Lastname", "Address"), height=400, selectmode="extended", yscrollcommand=scrollbary.set, xscrollcommand=scrollbarx.set)

scrollbary.config(command=tree.yview)

scrollbary.pack(side=RIGHT, fill=Y)

scrollbarx.config(command=tree.xview)

scrollbarx.pack(side=BOTTOM, fill=X)

tree.heading('Firstname', text="Firstname", anchor=W)

tree.heading('Lastname', text="Lastname", anchor=W)

tree.heading('Address', text="Address", anchor=W)

tree.column('#0', stretch=NO, minwidth=0, width=0)

tree.column('#1', stretch=NO, minwidth=0, width=200)

tree.column('#2', stretch=NO, minwidth=0, width=200)

tree.column('#3', stretch=NO, minwidth=0, width=300)

tree.pack()

with open('test.csv') as f:

reader = csv.DictReader(f, delimiter=',')

for row in reader:

firstname = row['firstname']

lastname = row['lastname']

address = row['address']

tree.insert("", 0, values=(firstname, lastname, address))

#============================INITIALIZATION==============================

if __name__ == '__main__':

root.mainloop()

Output

Run Quick Virus Scan for secure Download

Run Quick Scan for secure Download

Downloadable Source Code

I have here the list of Best Python Project with Source code free to download for free, I hope this can help you a lot.

Summary

The CSV File In Python is design in python programming language. Python is very smooth to research the syntax emphasizes readability and it is able to reduces time ingesting in developing.Also in this tutorial is the simplest way for the beginners or the student to Writing CSV File In Python .The project contains the python script (index.py) which is the main and the only one module of this project. It also includes the given CSV File that have data inside that named(test.csv).

Inquiries

If you have any questions or suggestions about on How To Read CSV File In Python With Source Code , please feel free to leave a comment below.

Author

angel jude suarez

Hello programmers, I'm Angel Jude R. Suarez, a student and a programmer of different programming languages like Python, Java, JavaScript, PHP, C, C++, Vb.net, and MySQL. and I have also knowledge in developing system or websites from Front-End to Back-End. and also a writer of itsourcecode.com.

Leave a Comment! Cancel Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.