Plot csv file in matplotlib

Question

I imported csv file as a list in python:

csv file:

2012,3,22
2012,3,30
2012,4,4
2012,4,7
2012,3,22
2012,3,22
2012,3,27
2012,3,30
2012,3,30
2012,4,7

code:

import csv
with open('file.csv', 'rb') as f:
    reader = csv.reader(f)
    date_list = list(reader)

print date_list

the output is:

 [['2012', '3', '22'], ['2012', '3', '27'], ['2012', '3', '30'], ['2012', '3', '30'], ['2012', '4', '7']]

Now I want to plot it with matplotlib. my code is here but I do not know to apply my data into the code to generate the bar chart

I need just Year and month from the data. as you can see it in example

Community · Accepted Answer · 2017-05-23 11:52:23Z

1

To get your monthly counts into the format you need for the stacked bar chart from your previous question

You could convert and extract as follows:

import numpy as np
a = [['2012', '3', '22'], ['2012', '3', '27'], ['2012', '3', '30'], ['2012', '3', '30'], ['2012', '4', '7'], ['2011', '2', '12'], ['2011', '2', '14'], ['2011', '10', '10']]
# convert all date parts to integers
a = [[int(e) for e in d] for d in a]

years = set(d[0] for d in a)
minyear, maxyear = min(years), max(years)
nyears = maxyear - minyear + 1
nmonths = 12

monthly_counts = np.zeros((nyears,nmonths))
for year,month,_ in a:
    monthly_counts[year-minyear,month-1] += 1

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Nov 3, 2015 at 12:27

xnx

25.7k11 gold badges75 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

Plot csv file in matplotlib

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related