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.



Python: Tips of the Day

Python: How do I copy a file in Python?

shutil has many methods you can use. One of which is:

from shutil import copyfile
copyfile(src, dst)
  • Copy the contents of the file named src to a file named dst.
  • The destination location must be writable; otherwise, an IOError exception will be raised.
  • If dst already exists, it will be replaced.
  • Special files such as character or block devices and pipes cannot be copied with this function.
  • With copy, src and dst are path names given as strings.

If you use os.path operations, use copy rather than copyfile. copyfile will only accept strings.

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