Multiple column plotting Python

Question

I've got data in the form:

Year      Month      State    Value
2001       Jan        AK        80
2001       Feb        AK        40
2001       Mar        AK        60
2001       Jan        LA        70
2001       Feb        LA        79
2001       Mar        LA        69
2001       Jan        KS        65
.
.

This data is only for Year 2001 and Months repeat on each State.

I want a basic graph with this data together in one based off the State with X-Axis being Month and Y-Axis being the Value.

When I plot with:

g = df.groupby('State')

for state, data in g:
    plt.plot(df['Month'], df['Value'], label=state)

plt.show()

I get a very wonky looking graph.

I know based off plotting these individually they aren't extremely different in their behaviour but they are not even close to being this much overlapped.

Is there a way of building more of a continuous plot?

Because it plots lines of the month, so for example first (Jan, 10), then (Jan, 30), then (Jan, 80), next the line moves to (Feb, 70), etc. — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Nov 9, 2018 at 18:30
Would I need to make some datetime substitute to make it continuous? — HelloToEarth
– HelloToEarth, Commented Nov 9, 2018 at 18:43
What is the 'Region' variable you're using for the groupby? This would be useful for reproducibility (or just the original dataset) — jwil
– jwil, Commented Nov 9, 2018 at 21:19
Sorry I've corrected the proper format. State not Region. This only corrected the question not the problem in the code. — HelloToEarth
– HelloToEarth, Commented Nov 9, 2018 at 21:21

jwil · Accepted Answer · 2018-11-09 21:25:54Z

1

Your problem is that inside your for loop you're referencing df, which still has the data for all the states. Try:

for state, data in g:
    plt.plot(data['Month'], data['Value'], label = state)
plt.legend()
plt.show()

Hopefully this helps!

answered Nov 9, 2018 at 21:25

jwil

5535 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Multiple column plotting Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related