<jupyter_start><jupyter_text>BP https://www.bp.com/en/global/corporate/energy-economics/energy-outlook.html<jupyter_code>df = pd.read_excel("data/bp-energy-outlook-2020-chart-data-pack.xlsx",
                  sheet_name = "Gas Share",
                  skiprows =3, index_col = "Scenarios")
df
#fix, ax = plt.subplots()
df.T.plot()
plt.title("Gas share in global power generation \n BP Energy Outlook 2020")
plt.ylabel("Share (0-1")
#ax.yaxis.set_major_formatter(mtick.PercentFormatter())
plt.savefig("figures/Gas share in global power generation BP Energy Outlook",
           dpi = 300)

plt.show()<jupyter_output><empty_output><jupyter_text>IEA<jupyter_code>df = pd.read_excel("data/NZE2021_AnnexA.xlsx",
                  sheet_name = "World_Elec",
                  skiprows=4,
                  usecols=[0,1,2,3,4,5], 
                  index_col = "Fuels")
df = df.iloc[0:19]

#Take a subset of only gas-based generation
df = df.loc[["Unabated Natural gas","Natural gas with CCUS", "Total generation"]]
df=df.T
df
df["Unabated Natural gas share"] = df["Unabated Natural gas"]/df["Total generation"]
df["Natural gas with CCUS share"] = df["Natural gas with CCUS"]/df["Total generation"]
df
df.to_excel("data/IEA Gas NZE.xlsx")
df.iloc[:,:2].plot(kind = "area", stacked = True)
plt.ylabel("TWh")
plt.title("Global Electricitiy Generation from Gas\n IEA Net Zero Scenario 2021")
plt.savefig("figures/Global electricity generation from gas in IEA Net Zero 2021 scenario", dpi = 300)
plt.show()
df.iloc[:,3:].plot(kind = "area", stacked = True)
plt.ylabel("Share (0-1")
plt.title("Gas share in global electricitiy generation\n IEA Net Zero Scenario 2021")
plt.savefig("figures/Gas share in global electricity generation IEA Net Zero 2021 scenario", dpi = 300)
plt.show()<jupyter_output><empty_output><jupyter_text>Shell  https://www.shell.com/energy-and-innovation/the-energy-future/scenarios/the-energy-transformation-scenarios.htmliframe=L3dlYmFwcHMvU2NlbmFyaW9zX2xvbmdfaG9yaXpvbnMv<jupyter_code>file = "data\shell-energy-transformation-scenarios-summary-data.xlsx"
shell = pd.read_excel(file, sheet_name = "Sheet1", skiprows = 23)
shell.columns=shell.iloc[0]

shell.drop(shell.index[0], axis=0, inplace=True)
shell.set_index("Scenarios",inplace=True)

shell.columns = shell.columns.astype(int)

shell= shell.T
shell
shell.plot()
plt.title("Gas share in global electricity generation \n Shell Energy Transformation Scenarios 2021")
plt.ylabel("Share (0-1")
plt.xlabel("Years")
plt.savefig("figures/Gas share in global electricity generation Shell", dpi = 300)
plt.show()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1397312859884837, 'fraction_numerical': 0.028406909788867563, 'mean_word_length': 4.804008908685969, 'pattern_counts': {'":': 0, '<': 13, '<?xml version=': 0, '>': 13, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '287592', 'license': 'MIT', 'n_tokens_mistral': 1011, 'n_tokens_neox': 916, 'n_words': 194, 'path': 'Assessing Institutional Scenarios.ipynb', 'repo_name': 'hbshrestha/Scenarios-Assessment-of-Integrated-Assessment-Models-and-Institutions', 'size': '2605'}