Homec4science
Diffusion cop-mining-participants (master) Browse

cop-mining-participants/code/scripts/plots/plot_fossil_fuel_industry.py
ea7760fc73b4master

Last Change
Raw File

plot_fossil_fuel_industry.py
View Options

""" Input: path to the complete dataset with cop
Plots the rate of fossil fuel industry representants for all meetings
"""
import pandas as pd
import matplotlib.pyplot as plt
def plot(path):
complete_data = pd.read_csv(path,
encoding="utf-8-sig")
metadata = pd.read_csv("../data/meetings_metadata.csv")
rate_result_df = pd.DataFrame(columns={"label", "fossil fuel industry rate"})
abs_result_df = pd.DataFrame(columns={"label", "fossil fuel industry participants"})
for label in metadata["label"]:
this_meeting = complete_data.loc[complete_data["meeting"] == label]
ff = this_meeting.groupby("fossil_fuel_industry")
n_ff = 0
n_notff = 0
for bool, people in ff:
if int(bool) == 0:
n_notff = len(people)
else:
n_ff = len(people)
rate_result_df = rate_result_df.append({
"label": label,
"fossil fuel industry rate": n_ff / (n_ff + n_notff)
}, ignore_index=True)
abs_result_df = abs_result_df.append({
"label": label,
"fossil fuel industry participants": n_ff
}, ignore_index=True)
plot_data = rate_result_df.loc[rate_result_df.label.apply(lambda l: l.startswith("cop"))]
plot_data = plot_data.set_index("label")
plot_data.plot(kind="line", xlabel="Meeting", ylabel="Fossil fuel industry rate",
title="Rate of fossil fuel industry representants (COP)", ylim=[0, 0.5])
plot_data2 = rate_result_df.loc[rate_result_df.label.apply(lambda l: l.startswith("sb"))]
plot_data2 = plot_data2.set_index("label")
plot_data2.plot(kind="line", xlabel="Meeting", ylabel="Fossil fuel industry rate",
title="Rate of fossil fuel industry representants (SB)", ylim=[0, 0.5])
# the plots of the absolut numbers
plot_data3 = abs_result_df.loc[abs_result_df.label.apply(lambda l: l.startswith("cop"))]
plot_data3 = plot_data3.set_index("label")
plot_data3.plot(kind="line", xlabel="Meeting", ylabel="Number of participants related with fossil fuel industry",
title="Number of fossil fuel industry representants (COP)")
plot_data4 = abs_result_df.loc[abs_result_df.label.apply(lambda l: l.startswith("sb"))]
plot_data4 = plot_data4.set_index("label")
plot_data4.plot(kind="line", xlabel="Meeting", ylabel="Number of participants related with fossil fuel industry",
title="Number of fossil fuel industry representants (SB)")
plt.show()
c4science · Help