PYTHON

filter blank rows python csv

def no_blank(fd):
    try:
        while True:
            line = next(fd)
            if len(line.strip()) != 0:
                yield line
    except:
        return
#Read the CSV file.
with open('campaign_monthly_report.csv', 'r') as csv_file:
    csv_reader = csv.DictReader(no_blank(csv_file))

remove empty rows csv python

import pandas as pd           # pip install pandas
df = pd.read_csv("Demo.csv")  # Enter your file name

df = df.dropna(inplace=True)