Q: Is There A Way To Ignore Blanks Cells In A Csv File But Still Graph The Data

I am doing a personal project for school using Python. I am just trying to clean and plot data from a csv file using matplotlib.pyplot and pandas. A problem I am running in to is f

Solution 1:

The easiest would probably be to loop over columns in the transposed DataFrame and plot them, dropping NAs:

from matplotlib.dates import DateFormatter


df = pd.read_csv('scores.csv', index_col=0)
df = df.T
df.index = pd.to_datetime(df.index, unit='s')

fig, ax = plt.subplots(figsize=(10,8))

fmt = DateFormatter("%M:%S")
ax.yaxis.set_major_formatter(fmt)

for c in df.columns:
    df[c] = pd.to_datetime('1970-01-01 00:' + df[c])
    df[c].dropna().plot(ax=ax, label=c, style='.-')

ax.legend()

Output:

P.S. I've added another '0' to unix time '132753600' bringing it to 2012 from 1974 to make it more in line with other records