How to plot multiple series of pandas data on the same graph?

Question

I have a data file which contains 100 columns of 100 different series of solar irradiance vs. time. I want to plot all of these series on the same graph with the same time x-axis. Is there a way to do this in pandas without specifying the column names? I have not included headers in the results file. The number of data series will also change so I want the code to be able to cope with varying numbers of data sets.

Shapshot of results file:

I have been using matplotlib but I think this would be easier to handle in pandas, however everything I can find online suggests using the column headers.

So far all I have is this:

data = pd.read_csv(outputFile)
data.plot.line(x="Time")

Michael · Accepted Answer · 2021-07-10 15:45:52Z

3

Read the first column as index, then all remaining columns will be plotted.

data = pd.read_csv(outputFile, header=None, index_col=0, sep='\s+')
data.plot.line(xlabel='Time')

edited Jul 10, 2021 at 15:45

answered Jul 10, 2021 at 1:28

Michael

5,3452 gold badges16 silver badges37 bronze badges

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

2 Comments

MUD Over a year ago

This doesn't give me any errors but also I don't get a plot out?

Michael Over a year ago

@UnaDavies Try to add in reading a file , sep='\s+'

Collectives™ on Stack Overflow

How to plot multiple series of pandas data on the same graph?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related