Financial-environmental Multi Time Series

Relation between emissions and Financial performance

@kaggle.giuliofabbri_environment_data

Table List

6 tables(184.18 KB)

Div

Roa

Roe

Scope1

Scope2

Tot Ass

Tot Ass

@kaggle.giuliofabbri_environment_data.tot_ass

62.78 KB
1449 rows
40 columns

company Company	country Country	economic_sector Economic Sector	sub_industry Sub Industry	pollution Pollution	metric Metric	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	weight_10 Weight 10	weight_11 Weight 11	weight_12 Weight 12	weight_13 Weight 13	weight_14 Weight 14	weight_15 Weight 15	weight_16 Weight 16	weight_17 Weight 17	weight_18 Weight 18	weight_19 Weight 19	weight_20 Weight 20	ec_dim_10 Ec Dim 10	ec_dim_11 Ec Dim 11	ec_dim_12 Ec Dim 12	ec_dim_13 Ec Dim 13	ec_dim_14 Ec Dim 14	ec_dim_15 Ec Dim 15	ec_dim_16 Ec Dim 16	ec_dim_17 Ec Dim 17	ec_dim_18 Ec Dim 18	ec_dim_19 Ec Dim 19	ec_dim_20 Ec Dim 20	quartile Quartile
IT Consulting & Other Services	non-polluter	TOTAL ASSETS	12303062	14975431	15856650	15848482	16778347	16992039	18531692	20474989	22362276	25440416	32925447	c(0.00681589243086572	0.04373107286749	0.010692193855132	0.0138477760416	0.204752188327689	0.0514404476748661	0.0325685332826685	0.00502865511000174	0.00155806870456857	0.0014227265823505	0.0116760972896768	0.0069469288675583	0.0016614827171359	0.020455330244199	0.0090030488258938	0.070355743566132	0.0023737878077699	0.0228353128764087	0.0121165270365592	0.0118448123527153	0.005056576693955	0.000932032998355044	0.0149695699968983	0.0037800201575997	0.0081579389315835
0.0022001543355581	0.000628678838694499	0.00386392617937844	0.0021188271822973	0.0123161331218444	0.0030447822501453	0.0168559943127589	0.0005707304719977	0.0036746798881394	0.0207899460518933	0.00693718401315872	0.0145226772897302	0.0031040602160779	0.0044962614159715	0.036363431101718	0.0051237214553665	0.0007478441702094	0.0113973324058847	0.0021003385509228	0.0166355024394769	0.0043500055000257	0.0547833665156706														nan				nan
0.00563296239470271	0.0058573804637283	0.010008392048117	0.0238895742705183	0.0006523900250675	0.0788563146808028	0.0074529577167404	0.0041487656696794	0.0282735770690056	0.00253399454369813)	c(0.00797138224233555	0.0448018710907657	0.0101434583091429	0.0150885006943201	0.212816739067055	0.0475856946781916	0.0322710591650975	0.0053197797198559	0.0015959871456918	0.0012619705583184	0.0112298772013008	0.00718614251400513	0.00182779678651834	0.0198307377889966	0.0089101253482757	0.0731541571622491	0.0023825373900989	0.0111516294907926	0.0130551248158081	0.0116597195545845	0.0048844669467022	0.0009524337937924	0.015245581642422	0.0038159641187639	0.0082619830609186					nan
0.00242136741721558	0.000744364614793526	0.00377211293074098	0.0022405992370211	0.0126862959817188	0.0035568108953449	0.0157277898121455	0.0007314297891789	0.0038442514645586	0.0182881400675495	0.0072216781528202	0.0150187633538501	0.0027594294644519	0.0021813545419221	0.0364027511988699	0.0051053703471164	0.000843265462497	0.0084261707109455	0.0021697712192801	0.0183333853423331	0.0047113638483534	0.0537817273919433														nan				nan
0.00543599620036783	0.00601149586831648	0.0107100888386393	0.0227094018599372	0.000654991889662	0.0863822786169358	0.0079211168712403	0.0048194218073758	0.0291343767286889	0.00238522442712371)	c(0.00839038068867866	0.0463441585856554	0.0090657479567961	0.0156493022717706	0.220607804041997	0.0426929866691216	0.0335310443164778	0.0050749774501623	0.0016763670169804	0.0011486032270949	0.0110965855601454	0.00608223797821314	0.00187241533782237	0.0173896422606752	0.0183050536868853	0.0712899136592092	0.0025866542557619	0.0109045079025071	0.0163530578768917	0.0100484976824857	0.0050751891059834	0.0009131255433423	0.0145847793196033	0.0039069479226683	0.0088389582153596					nan
0.00259749315035992	0.000798980617308108	0.0033891398934673	0.0026394010029355	0.0130372048697555	0.0038669518512966	0.0154614577305541	0.0008338181071802	0.0038902339916164	0.0151836594653747	0.00787835880048665	0.0159902014868912	0.0050702151941878	0.0024515035477637	0.0326008169827915	0.0053676974507285	0.0009158347378522	0.0072153866263917	0.0025247295830463	0.0182082211487371	0.0051379450569363	0.0552977289572743														nan				nan
0.00525968525211034	0.00631702248915168	0.0108080457620458	0.0194749812379549	0.0006138547951134	0.0899521365441822	0.0064592065200846	0.0047770290216757	0.026936371192082	0.00261077455313326)	c(0.00867902796364519	0.0489965733585904	0.0082099968458158	0.0163745408008764	0.219437246938121	0.0412106355547653	0.0347139607828351	0.0050124133624434	0.0017506482068239	0.0004104998422907	0.0111288391075686	0.00612706172156192	0.00224549437610151	0.0187019478576211	0.0193043355664256	0.0730674385772292	0.0027212678552679	0.0117607985766236	0.0143461370977746	0.0079514953035869	0.0051913225119583	0.0009288769183498	0.0144886839346853	0.003895662122596	0.0080127154188075					nan
0.00280625052272536	0.000778866497727034	0.00280173863878641	0.0026301342616785	0.0135772165687451	0.0035907783696647	0.0152387661571849	0.0008090614554434	0.003839400205844	0.0133078397378715	0.0087893842966478	0.0171920975658895	0.0048185540452463	0.001318681457092	0.032961012550214	0.0056838018451655	0.0008776241292092	0.0065617293587299	0.0028277743831861	0.0192955735633885	0.0048119825429684	0.0540517014858399														nan				nan
0.00566436224617726	0.00627261611601516	0.0113185364733231	0.0184215637604321	0.0005851922778441	0.0934692150240587	0.0076859195391558	0.0049904459255789	0.0223959475516903	0.00278248358948707)	c(0.00889352743286809	0.0479094559803646	0.0080288159510381	0.0152556514086505	0.222855364648837	0.0399858351692768	0.0366621168594114	0.005509441671294	0.00184158679994	0.000409206173777	0.0115796866221945	0.00580079063636538	0.00259118784300276	0.018672416947727	0.0176515217525267	0.0747257118580282	0.0027707286419268	0.0127399875475805	0.0134492075741527	0.0068794650012193	0.004761050224719	0.0009141003347416	0.014547067453851	0.0039725332504823	0.0079264068054523					nan
0.00323188067714199	0.000745984975034861	0.00249843267674726	0.0028388413275879	0.0140356657485918	0.0036415108987675	0.0141690287969367	0.000727030036208	0.0034130551204023	0.00972288710569041	0.0095098030618324	0.0177474625782438	0.0033748908140397	0.0012859251004963	0.0254015262431934	0.0058334142275278	0.0009172154962485	0.0056916730538167	0.0048460638674408	0.0206712724934697	0.0047668278766545	0.0538249234665722														nan				nan


CREATE TABLE tot_ass (
  "company" VARCHAR,
  "country" VARCHAR,
  "economic_sector" VARCHAR,
  "sub_industry" DOUBLE,
  "pollution" DOUBLE,
  "metric" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" VARCHAR,
  "n_2014" VARCHAR,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" VARCHAR,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "weight_10" DOUBLE,
  "weight_11" DOUBLE,
  "weight_12" DOUBLE,
  "weight_13" DOUBLE,
  "weight_14" VARCHAR,
  "weight_15" VARCHAR,
  "weight_16" DOUBLE,
  "weight_17" DOUBLE,
  "weight_18" DOUBLE,
  "weight_19" DOUBLE,
  "weight_20" DOUBLE,
  "ec_dim_10" DOUBLE,
  "ec_dim_11" DOUBLE,
  "ec_dim_12" DOUBLE,
  "ec_dim_13" DOUBLE,
  "ec_dim_14" DOUBLE,
  "ec_dim_15" DOUBLE,
  "ec_dim_16" DOUBLE,
  "ec_dim_17" VARCHAR,
  "ec_dim_18" DOUBLE,
  "ec_dim_19" DOUBLE,
  "ec_dim_20" DOUBLE,
  "quartile" VARCHAR
);