• Home
  • Subscribe
  • Contribute Us
    • Share Your Interview Experience
  • Contact Us
  • About
    • About CSEstack
    • Campus Ambassador
  • Forum & Discus
  • Tools for Geek
  • LeaderBoard
CSEstack

What do you want to Learn Today?

  • Programming
    • Tutorial- C/C++
    • Tutorial- Django
    • Tutorial- Git
    • Tutorial- HTML & CSS
    • Tutorial- Java
    • Tutorial- MySQL
    • Tutorial- Python
    • Competitive Coding Challenges
  • CSE Subject
    • (CD) Compiler Design
    • (CN) Computer Network
    • (COA) Computer Organization & Architecture
    • (DBMS) Database Management System
    • (DS) Data Structure
    • (OS) Operating System
    • (ToA) Theory of Automata
    • (WT) Web Technology
  • Interview Questions
    • Interview Questions- Company Wise
    • Interview Questions- Coding Round
    • Interview Questions- Python
    • Interview Questions- REST API
    • Interview Questions- Web Scraping
    • Interview Questions- HR Round
    • Aptitude Preparation Guide
  • GATE 2022
  • Linux
  • Trend
    • Full Stack Development
    • Artificial Intelligence (AI)
    • BigData
    • Cloud Computing
    • Machine Learning (ML)
  • Write for Us
    • Submit Article
    • Submit Source Code or Program
    • Share Your Interview Experience
  • Tools
    • IDE
    • CV Builder
    • Other Tools …
  • Jobs

How Python Read CSV File into Array List | Explained With Example

Aniruddha Chaudhari/61473/2
CodePython

Want to learn how Python read CSV file into array list?

Why is it so popular data format for data science?

Before that let’s understand the format of the contents stored in a .csv file. And

What is a CSV file?

CSV stands for Comma Separated Variable. It is file format which is used to store the data in tabular format. This is the best format to store structured data.

So you might get what does it actually. It stored the data and separated data entries using delimiter comma (,). Many websites used CSV file format for sharing valuable data.

One of the primary examples of CSV files is storing contact information. You may have used CSV files format for import and export the contact data files.

At the end of this post, I will mention CSV file link from where you can download the .csv file. You can use this file for practicing, parsing and manipulating data.

As of now for simplicity, consider this simple CSV file containing cricket related data.

For example:

Virat,45,43,Ind
Cook,25,27,Eng
Root,29,14,Eng

This is the example of cricket match info where the name of each player, run they have scored, balls they have faced and the team they belong stored in CSV files.

Save this file as “crickInfo.csv”.

How Python Read CSV File into Array List?

As like any text file you can read and split the content using comma operator. But there is an automated module called CSV. Just import it and it will do the things for you.

In this post, I will show you how to read a CSV file in python?

First of all, you need to import the CSV module.

import csv

Open the file as a usual text file.

file_CSV = open(<CSV_file_name>)

The open() is a built-in function for file handling in Python.

Then we need CSV.reader() to get structured data from .csv files.

data_CSV = csv.reader(file_CSV)

A list is the most used and convenient data structure in python so converting CSV files data into a list makes the data manipulation easy.

list_CSV = list(data_CSV)

Python Read CSV File into Array List:

import csv

file_CSV = open('crickInfo.csv')
data_CSV = csv.reader(file_CSV)
list_CSV = list(data_CSV)

print list_CSV

Save this program as readCSVFile.py and run it.

Output:

python readCSVFile.py
[['Virat', '45', '43', 'Ind'], ['Cook', '25', '27', 'Eng'], ['Root', '29', '14', 'Eng']]

If you don’t have .csv file in your current directory, you will get the following error.

Traceback (most recent call last):
File "readCSVFile.py", line 3, in
file_CSV = open('crickInfo.csv')
IOError: [Errno 2] No such file or directory: 'crickInfo.csv'

So just ensure you have .csv file in the current directory where the actual .py file is stored.

Manipulating CSV file data using Python Program:

Now you can manipulate and play with the data.

You might be curious.

Print name of the player and the team he belongs.

import csv

file_CSV = open('crickInfo.csv')
data_CSV = csv.reader(file_CSV)
list_CSV = list(data_CSV)

for row in list_CSV:
print row[0], '|', row[3] 

Output:

Virat | Ind
Cook | Eng
Root | Eng

You can see there are some repeated countries. You can find all the names of countries without repetition by finding unique elements from the list in Python.

Like this, you can do a lot many things around CSV file contents.

Use of CSV file in Data Science Project

This is a simple tutorial to deal with CSV files. Hope you find it useful in your programming or in the project.

The CSV file is popular among the data scientist as they use it for reading and analyzing the data.

Here is a sample CSV file data you can download.

Now you know, How Python read CSV file into array list? So use this code and analyze contents in CSV file; you will find really worth information.

Kindly write in a comment if you have used CSV file in your project or you have done something interesting stuff with .csv files.

Happy Pythoning!

Python Interview Questions eBook

Python
Aniruddha Chaudhari
I am complete Python Nut, love Linux and vim as an editor. I hold a Master of Computer Science from NIT Trichy. I dabble in C/C++, Java too. I keep sharing my coding knowledge and my own experience on CSEstack.org portal.

Your name can also be listed here. Got a tip? Submit it here to become an CSEstack author.

Comments

  • Reply
    viswanadh
    August 3, 2017 at 6:37 pm

    Good post

    Thank u for sharing

  • Reply
    Aniruddha Chaudhari
    July 16, 2018 at 9:57 am

    Thanks, Viswanadh!

Leave a Reply Cancel reply

Basic Python Tutorial

  1. Python- Tutorial Overview
  2. Python- Applications
  3. Python- Setup on Linux
  4. Python- Setup on Windows
  5. Python- Basic Syntax
  6. Python- Variable Declaration
  7. Python- Numeric Data Types
  8. Python- NoneType
  9. Python- if-else/elif
  10. Python- for/while else
  11. Python- User Input
  12. Python- Multiline User Input
  13. Python- String Formatting
  14. Python- Find Substring in String
  15. Python- Bitwise Operators
  16. Python- Range Function
  17. Python- List
  18. Python- List Vs Tuple
  19. Python- Compare Two Lists
  20. Python- Sorting List
  21. Python- Delete Element from List
  22. Python- Dictionary
  23. Python- ‘is’ vs ‘==’
  24. Python- Mutable vs Immutable
  25. Python- Generator & Yield
  26. Python- Fibonacci Generator
  27. Python- Assert Statement
  28. Python- Exception Handling 
  29. Python- RegEx
  30. Python- Lambda Function
  31. Python- Installing Modules
  32. Python- Important Modules
  33. Python- Find all Installed Modules
  34. PyCharm- IDE setup
  35. Python- File Handling
  36. Python- Monkey Patching
  37. Python- Decorators
  38. Python- Instance vs Static vs Class Method
  39. Python- Name Mangling
  40. Python- Working with GUI
  41. Python- Read Data from Web URL
  42. Python- Memory Management
  43. Python- Virtual Environment
  44. Python- Calling C Function

Python Exercise

  1. Python- Tricky Questions
  2. Python- Interview Questions (60+)
  3. Python- Project Ideas (45+)
  4. Python- MCQ Test Online
  5. Python- Coding Questions (50+)
  6. Python- Competitive Coding Questions (20+)

Python String

  1. Reverse the String
  2. Permutations of String
  3. Padding Zeros to String/Number

Python List

  1. Randomly Select Item from List
  2. Find Unique Elements from List
  3. Are all Elements in List Same?

Python Dictionary

  1. Set Default Value in Dictionary
  2. Remove all 0 from a dictionary

File Handling

  1. Python- Read CSV File into List
  2. Check if the File Exist in Python
  3. Find Longest Line from File

Compilation & Byte Code

  1. Multiple Py Versions on System
  2. Convert .py file .pyc file
  3. Disassemble Python Bytecode

Algorithms

  1. Sorting- Selection Sort
  2. Sorting- Quick Sort

Other Python Articles

  1. Clear Py Interpreter Console
  2. Can I build Mobile App in Python?
  3. Extract all the Emails from File
  4. Python Shell Scripting

© 2022 – CSEstack.org. All Rights Reserved.

  • Home
  • Subscribe
  • Contribute Us
    • Share Your Interview Experience
  • Contact Us
  • About
    • About CSEstack
    • Campus Ambassador
  • Forum & Discus
  • Tools for Geek
  • LeaderBoard