Question

Python help asap! Please give an example of code that reads a csv file then uses list comprehension to remove all rows that have empty values.

Answer 1

"""
  Python code - read csv, ignore empty lines using list comprehension
"""

import csv

with open('file.csv', newline = '') as fileObj:
  csv_reader = csv.reader(fileObj, delimiter = ',')
  lines = [l for l in csv_reader if l]

print(lines)

main.py saved https://UnevenUnused Ruby.imtusharsharma.repl.run 1 2 3 4 Python code - read csv, ignore empty lines using list comprehension [['Bob', '99', 'B'], ['sinka', '92', 'A'], ['sia', '74', 'C'], ['Mobley', '55', 'D']] 5 import csv 6 7 8 with open('file.csv', newline = "') as fileobj: csv_reader = csv.reader(fileobj, delimiter = ',') lines = [1 for 1 in csv_reader if 1] 9 10 11 print(lines)

file.csv saved 1 Bob, 89,B 2 Sinka, 92,A 3 4 Sia, 74, 5 6 Mobley,55,D

Note: Please drop me a comment, for queries.