Creating a plot with two lines in using Panda (python)

Question

I'm trying to compare two sets of data - CO2 emissions from the UK and Thailand using a publicly available data set. I've used the below code to get separate line graphs however I am struggling to merge the two lines into one plot, can someone please help?

import pandas as pd

import matplotlib.pyplot as plt

download_url = (
"https://raw.githubusercontent.com/owid/co2-data/master/owid-co2-data.csv"
)

df = pd.read_csv(download_url)
type(df)

pd.set_option("display.max.columns", None)

uk = df[(df["country"] == 'United Kingdom')]
thailand = df[(df["country"] == 'Thailand')]

%matplotlib

uk.plot(x="year", y="co2")

thailand.plot(x="year", y="co2")

Quang Hoang · Accepted Answer · 2021-03-17 13:43:56Z

2

You can create an axis instance and pass that to plot:

fig, ax = plt.subplots()

uk.plot(x="year", y="co2", ax=ax, label='UK')

thailand.plot(x="year", y="co2", ax=ax, label='Thailand')

You can also use seaborn:

import seaborn as sns

# read data
df = pd.read_csv(download_url)

plot_data = df[df['country'].isin(['United Kingdom', 'Thailand'])

sns.lineplot(x='year', y='co2', hue='country')

answered Mar 17, 2021 at 13:43

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

Creating a plot with two lines in using Panda (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