Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

Python CSV File Reading and Writing - Exercises, Practice, Solution

Python CSV File Reading and Writing [11 exercises with solution]

[An editor is available at the bottom of the page to write and execute the scripts.]

1. Write a Python program to read each row from a given csv file and print a list of strings. Go to the editor
Click me to see the sample solution

2. Write a Python program to read a given CSV file having tab delimiter. Go to the editor
Click me to see the sample solution

3. Write a Python program to read a given CSV file as a list.
Click me to see the sample solution

4. Write a Python program to read a given CSV file as a dictionary. Go to the editor
Click me to see the sample solution

5. Write a Python program to read a given CSV files with initial spaces after a delimiter and remove those initial spaces. Go to the editor
Click me to see the sample solution

6. Write a Python program that reads a CSV file and remove initial spaces, quotes around each entry and the delimiter. Go to the editor
Click me to see the sample solution

7. Write a Python program to read specific columns of a given CSV file and print the content of the columns. Go to the editor
Click me to see the sample solution

8. Write a Python program that reads each row of a given csv file and skip the header of the file. Also print the number of rows and the field names. Go to the editor
Click me to see the sample solution

9. Write a Python program to create an object for writing and iterate over the rows to print the values. Go to the editor
Click me to see the sample solution

10. Write a Python program to write a Python list of lists to a csv file. After writing the CSV file read the CSV file and display the content. Go to the editor
Click me to see the sample solution

11. Write a Python program to write a Python dictionary to a csv file. After writing the CSV file read the CSV file and display the content. Go to the editor
Click me to see the sample solution

Python Code Editor:

More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.

Test your Python skills with w3resource's quiz



Python: Tips of the Day

Find current directory and file's directory:

To get the full path to the directory a Python file is contained in, write this in that file:

import os 
dir_path = os.path.dirname(os.path.realpath(__file__))

(Note that the incantation above won't work if you've already used os.chdir() to change your current working directory, since the value of the __file__ constant is relative to the current working directory and is not changed by an os.chdir() call.)

To get the current working directory use

import os
cwd = os.getcwd()

Documentation references for the modules, constants and functions used above:

  • The os and os.path modules.
  • The __file__ constant
  • os.path.realpath(path) (returns "the canonical path of the specified filename, eliminating any symbolic links encountered in the path")
  • os.path.dirname(path) (returns "the directory name of pathname path")
  • os.getcwd() (returns "a string representing the current working directory")
  • os.chdir(path) ("change the current working directory to path")

Ref: https://bit.ly/3fy0R6m