Issue
I'm reading a pandas dataframe, and trying to generate a plot from it. In the plot, the data points seem to be getting connected in an order determined by ascending y value, resulting in a weird zig-zagging plot like this:
The code goes something like this:
from pandas import DataFrame as df
import matplotlib as mpl
mpl.use('Agg')
import matplotlib.pyplot as plt
data = df.from_csv(...)
plt.plot(data['COL1'], data['COL2'])
Any suggestions on how to fix the order in which the dots are connected (i.e. connect them in the sequence in which they appear going from left to right on the plot)? Thanks.
Solution
Is the order of values in COL1 different from the csv?
You can sort by COL1 first, add this before plotting:
data.sort('COL1', inplace=True)
Answered By - Rutger Kassies
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.