import pandas as pd file = pd.read_csv("/my/path/to/spreadsheet.csv", index_col=0) file.dropna(how="any", inplace=True) file = file.fillna("", inplace=False) print(file)