如何使用csv文件制作直线图。有4列。每年都是十年

Question

我是个新手，想做一张线图。我想在y轴上画一个几十年的x轴和#宗教线，但是有两条线，一个宗教学校和一个非宗教学校。

这是我的csv文件。

https://drive.google.com/file/d/16XuvoQKSrSMaUPsfHOWY6cBy1ry6UNz6/view?usp=sharing

Answer 1

import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

df = pd.read_csv('ReligiousRate.csv', dtype='string')

df_religious = df[['Religious', 'founded1']]
df_non_religious = df[['Non-Religious', 'founded2']]

dfs = [df_religious, df_non_religious]
names = ['Religious Schools', 'Non Religious Schools']

counts = []
for df, name in zip(dfs, names):
    df.columns = ['Name', 'Founded']
    df['Founded'] = pd.to_datetime(df['Founded'], yearfirst=True)
    df = df.set_index('Founded')
    df_decades = df.resample('10AS').count()
    df_decades.columns = [name]
    counts.append(df_decades)

sns.set_palette(["#090364", "#ff0000"])
sns.lineplot(data=pd.concat(counts), dashes=False)
plt.show()

输出：

​

​