Turn line chart into bar plot in python code for-loop with matplotlib

Question

I have a script that takes multiple .csv files and outputs multiple line plots. I would like for these plots to be bar charts since they're showing rainfall. But I haven't been able to get plot.bar.() to work. This is the code that works for me so far but it's not correct. Any help?

import pandas as pd
import time
import os
import matplotlib.pyplot as plt

files = ['w.pod.csv',
    't.pod.csv',
    'r.pod.csv',
    'n.pod.csv',
    'm.pod.csv',
    'k.pod.csv',
    'j.pod.csv',
    'h.pod.csv',
    'g.pod.csv',
    'c.pod.csv',
    'b.pod.csv']

for f in files:
    fn = f.split('.')[0]
    dat = pd.read_csv(f)
    df0 = dat.loc[:, ['TimeStamp', 'RF']]
    # Change time format
    df0["time"] = pd.to_datetime(df0["TimeStamp"])
    df0["day"] = df0['time'].map(lambda x: x.day)
    df0["month"] = df0['time'].map(lambda x: x.month)
    df0["year"] = df0['time'].map(lambda x: x.year)
    df0.to_csv('{}_1.csv'.format(fn), na_rep="0")  # write to csv

    # Combine for daily rainfall
    df1 = pd.read_csv('{}_1.csv'.format(fn), encoding='latin-1',
                  usecols=['day', 'month', 'year', 'RF', 'TimeStamp'])
    df2 = df1.groupby(['day', 'month', 'year'], as_index=False).sum()
    df2.to_csv('{}_2.csv'.format(fn), na_rep="0", header=None)  # write to csv

    # parse date
    df3 = pd.read_csv('{}_2.csv'.format(fn), header=None, index_col='datetime',
                 parse_dates={'datetime': [1,2,3]},
                 date_parser=lambda x: pd.datetime.strptime(x, '%d %m %Y'))

    def dt_parse(date_string):
        dt = pd.datetime.strptime(date_string, '%d %m %Y')
        return dt

    # sort datetime
    df4 = df3.sort()
    final = df4.reset_index()

    # rename columns
    final.columns = ['date', 'bleh', 'rf']

    final[['date','rf']].plot()
    plt.suptitle('{} Rainfall 2015-2016'.format(fn), fontsize=20)
    plt.xlabel('Date', fontsize=18)
    plt.ylabel('Rain / mm', fontsize=16)
    plt.savefig('{}.png'.format(fn))

This is an extension of my previous question: Automate making multiple plots in python using several .csv files

jezrael · Accepted Answer · 2017-02-24 15:17:43Z

1

Use DataFrame.plot.bar:

final[['date','rf']].plot.bar()

Or DataFrame.plot:

final[['date','rf']].plot(kind='bar')

edited Feb 24, 2017 at 15:17

answered Feb 24, 2017 at 15:15

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JAG2024 Over a year ago

That was easy! Thanks!! Also do you know the code for changing the xtick labels? Right now it's trying to put all 365 dates but the axis gets clogged. It would be good if every 30 ticks (days) are labeled instead.

JAG2024 Over a year ago

Thanks! Please check out my other question: stackoverflow.com/questions/42444020/…

Collectives™ on Stack Overflow

Turn line chart into bar plot in python code for-loop with matplotlib

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related