Python Pandas how to plot multiple colmuns on x axis?

Question

I have a dataframe that looks like this:

import pandas as pd
data = {'Floor': [1, 2, 3, 4], 'IDR 1': [15, 6, 7, 9], 'IDR 2': [36, 12, 78, 23]}
df = pd.DataFrame(data)

df:

   Floor  IDR 1  IDR 2
0      1     15     36
1      2      6     12
2      3      7     78
3      4      9     23

And I want to plot this dataframe as a line chart where y-axis is the floor. I have read the documentation on df.plot() method and it seem you can input more than one columns of data into y kwarg but not to the x.

So I have been reseaching to find a solution and I came across this question that resemles the most to my problem: Plotting multiple columns in a pandas line graph

I have this code: df.plot(kind="line", y=["IDR 1", "IDR 2"], x="Floor", grid=True, xlabel="Floor", ylabel=data)

Basicly I just want to swap the axises.

Panda Kim · Accepted Answer · 2024-07-14 10:39:03Z

0

Code

use loop

import pandas as pd
import matplotlib.pyplot as plt

cols = ['IDR 1', 'IDR 2']

fig, ax = plt.subplots()

for col in cols:
    df.plot(x=col, y='Floor', ax=ax)
    
plt.xlabel('IDR value')
plt.ylabel('Floor')
plt.legend(labels=cols)
plt.show()

answered Jul 14, 2024 at 10:39

Panda Kim

13.6k2 gold badges8 silver badges15 bronze badges

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

Comments

onlyf · Accepted Answer · 2024-07-14 19:24:52Z

0

import pandas as pd
import matplotlib.pyplot as plt

# Sample data
data = {'Floor': [1, 2, 3, 4], 'IDR 1': [15, 6, 7, 9], 'IDR 2': [36, 12, 78, 23]}
df = pd.DataFrame(data)

# Columns to plot
cols = ['IDR 1', 'IDR 2']

# Create a figure and axis
fig, ax = plt.subplots()

# Plot each column
for col in cols:
    ax.plot(df[col], df['Floor'], marker='o', label=col)

# Set labels and legend
ax.set_xlabel('IDR value')
ax.set_ylabel('Floor')
ax.legend()

# Show the plot
plt.show()

answered Jul 14, 2024 at 19:24

onlyf

8833 gold badges23 silver badges42 bronze badges

Collectives™ on Stack Overflow

Python Pandas how to plot multiple colmuns on x axis?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related