Skip to content

Instantly share code, notes, and snippets.

View Nikithakatta30's full-sized avatar

Nikithakatta30

View GitHub Profile
@Nikithakatta30
Nikithakatta30 / Project.csv
Created May 12, 2023 23:31
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 22 columns, instead of 15 in line 7.
Country,Code,Year,age20_40,age10_14,Allages,age70,age30_34,age15_19,age25_29,age50_69,ageStandard,age15_49,Happiness_Rank,Region,Happiness_Score,Economy,Social_,Health,Freedom,Corruption,Generosity
Afghanistan,AFG,2015,6.14,1.78,3.88,5.72,7.12,4.44,6.6,7.21,5.11,6.45,153,Southern Asia,3.58,0.32,0.3,0.3,0.23,0.1,0.37
Afghanistan,AFG,2016,6.12,1.79,3.9,5.7,7.11,4.43,6.59,7.2,5.11,6.44,154,Southern Asia,3.36,0.38,0.11,0.17,0.16,0.07,0.31
Afghanistan,AFG,2017,6.09,1.8,3.92,5.69,7.09,4.43,6.56,7.2,5.11,6.43,141,Southern Asia,3.79,0.4,0.58,0.18,0.11,0.06,0.31
Afghanistan,AFG,2018,6.09,1.82,3.94,5.69,7.11,4.44,6.57,7.23,5.12,6.43,145,Southern Asia,3.63,0.33,0.54,0.26,0.08,0.04,0.19
Afghanistan,AFG,2019,6.08,1.84,3.96,5.75,7.12,4.47,6.58,7.29,5.13,6.42,154,Southern Asia,3.2,0.35,0.52,0.36,0.0,0.02,0.16
Albania,ALB,2015,3.06,0.71,2.96,4.0,3.26,2.04,3.14,3.94,2.61,3.16,95,Central and Eastern Europe,4.96,0.88,0.8,0.81,0.36,0.06,0.14
Albania,ALB,2016,3.06,0.72,2.98,3.99,3.25,2.03,3.15,3.96,2.61,3.16,109,Central and Easte
@Nikithakatta30
Nikithakatta30 / depression.csv
Created May 12, 2023 20:48
We can't make this file beautiful and searchable because it's too large.
Country,Code,Year,age20_40,age10_14,Allages,age70,age30_34,age15_19,age25_29,age50_69,agestand,age15_49
Afghanistan,AFG,1990,6.188668667129671,1.79960618322535,4.002842927514609,5.58494584162613,7.34899181136769,4.47887790511073,6.7789877221291,6.96148721783941,5.12529130805948,6.4309219626415794
Afghanistan,AFG,1991,6.1642821210083,1.7841570276786198,3.95582816037805,5.58313667977515,7.32785202725548,4.43568136622434,6.71914406269985,6.96688736624772,5.11630648212307,6.373603552822551
Afghanistan,AFG,1992,6.1351385400105,1.7727095146499598,3.90253597331266,5.581337166458209,7.30431282733622,4.396269778636331,6.641635707230701,6.979891985526381,5.10655802716073,6.323968604473131
Afghanistan,AFG,1993,6.12672951325959,1.76115507686698,3.86019281418462,5.5814596394122,7.275676965105631,4.3766603599932905,6.609489331820679,6.987642567612149,5.10032803380605,6.32415732280988
Afghanistan,AFG,1994,6.10909574238705,1.75758286319751,3.8163479656403503,5.58241881168802,7.246834840984071,4.37808436347119,6.6035276677860
@Nikithakatta30
Nikithakatta30 / 2019.csv
Created May 12, 2023 20:26
Overall rank Country or region Score GDP per capita Social support Healthy life expectancy Freedom to make life choices Generosity Perceptions of corruption
1 Finland 7.769 1.340 1.587 0.986 0.596 0.153 0.393
2 Denmark 7.600 1.383 1.573 0.996 0.592 0.252 0.410
3 Norway 7.554 1.488 1.582 1.028 0.603 0.271 0.341
4 Iceland 7.494 1.380 1.624 1.026 0.591 0.354 0.118
5 Netherlands 7.488 1.396 1.522 0.999 0.557 0.322 0.298
6 Switzerland 7.480 1.452 1.526 1.052 0.572 0.263 0.343
7 Sweden 7.343 1.387 1.487 1.009 0.574 0.267 0.373
8 New Zealand 7.307 1.303 1.557 1.026 0.585 0.330 0.380
9 Canada 7.278 1.365 1.505 1.039 0.584 0.285 0.308
@Nikithakatta30
Nikithakatta30 / 2018.csv
Created May 12, 2023 20:26
Overall rank Country or region Score GDP per capita Social support Healthy life expectancy Freedom to make life choices Generosity Perceptions of corruption
1 Finland 7.632 1.305 1.592 0.874 0.681 0.202 0.393
2 Norway 7.594 1.456 1.582 0.861 0.686 0.286 0.340
3 Denmark 7.555 1.351 1.590 0.868 0.683 0.284 0.408
4 Iceland 7.495 1.343 1.644 0.914 0.677 0.353 0.138
5 Switzerland 7.487 1.420 1.549 0.927 0.660 0.256 0.357
6 Netherlands 7.441 1.361 1.488 0.878 0.638 0.333 0.295
7 Canada 7.328 1.330 1.532 0.896 0.653 0.321 0.291
8 New Zealand 7.324 1.268 1.601 0.876 0.669 0.365 0.389
9 Sweden 7.314 1.355 1.501 0.913 0.659 0.285 0.383
@Nikithakatta30
Nikithakatta30 / 2017.csv
Created May 12, 2023 20:26
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 12 columns, instead of 6 in line 5.
"Country","Happiness.Rank","Happiness.Score","Whisker.high","Whisker.low","Economy..GDP.per.Capita.","Family","Health..Life.Expectancy.","Freedom","Generosity","Trust..Government.Corruption.","Dystopia.Residual"
"Norway",1,7.53700017929077,7.59444482058287,7.47955553799868,1.61646318435669,1.53352355957031,0.796666502952576,0.635422587394714,0.36201223731041,0.315963834524155,2.27702665328979
"Denmark",2,7.52199983596802,7.58172806486487,7.46227160707116,1.48238301277161,1.55112159252167,0.792565524578094,0.626006722450256,0.355280488729477,0.40077006816864,2.31370735168457
"Iceland",3,7.50400018692017,7.62203047305346,7.38596990078688,1.480633020401,1.6105740070343,0.833552122116089,0.627162635326385,0.475540220737457,0.153526559472084,2.32271528244019
"Switzerland",4,7.49399995803833,7.56177242040634,7.42622749567032,1.56497955322266,1.51691174507141,0.858131289482117,0.620070576667786,0.290549278259277,0.367007285356522,2.2767162322998
"Finland",5,7.4689998626709,7.52754207581282,7.41045764952898,1.4435719
@Nikithakatta30
Nikithakatta30 / 2016.csv
Created May 12, 2023 20:25
Country Region Happiness Rank Happiness Score Lower Confidence Interval Upper Confidence Interval Economy (GDP per Capita) Family Health (Life Expectancy) Freedom Trust (Government Corruption) Generosity Dystopia Residual
Denmark Western Europe 1 7.526 7.46 7.592 1.44178 1.16374 0.79504 0.57941 0.44453 0.36171 2.73939
Switzerland Western Europe 2 7.509 7.428 7.59 1.52733 1.14524 0.86303 0.58557 0.41203 0.28083 2.69463
Iceland Western Europe 3 7.501 7.333 7.669 1.42666 1.18326 0.86733 0.56624 0.14975 0.47678 2.83137
Norway Western Europe 4 7.498 7.421 7.575 1.57744 1.1269 0.79579 0.59609 0.35776 0.37895 2.66465
Finland Western Europe 5 7.413 7.351 7.475 1.40598 1.13464 0.81091 0.57104 0.41004 0.25492 2.82596
Canada North America 6 7.404 7.335 7.473 1.44015 1.0961 0.8276 0.5737 0.31329 0.44834 2.70485
Netherlands Western Europe 7 7.339 7.284 7.394 1.46468 1.02912 0.81231 0.55211 0.29927 0.47416 2.70749
New Zealand Australia and New Zealand 8 7.334 7.264 7.404 1.36066 1.17278 0.83096 0.58147 0.41904 0.49401 2.47
@Nikithakatta30
Nikithakatta30 / Fifa.csv
Created May 7, 2023 22:30
Date ARG BRA ESP FRA GER ITA
1993-08-08 5.0 8.0 13.0 12.0 1.0 2.0
1993-09-23 12.0 1.0 14.0 7.0 5.0 2.0
1993-10-22 9.0 1.0 7.0 14.0 4.0 3.0
1993-11-19 9.0 4.0 7.0 15.0 3.0 1.0
1993-12-23 8.0 3.0 5.0 15.0 1.0 2.0
1994-02-15 9.0 2.0 6.0 14.0 1.0 7.0
1994-03-15 8.0 2.0 6.0 15.0 1.0 11.0
1994-04-19 10.0 1.0 7.0 15.0 2.0 13.0
1994-05-17 6.0 1.0 9.0 17.0 2.0 16.0
@Nikithakatta30
Nikithakatta30 / timeseries.csv
Last active May 7, 2023 22:19
sno Period Revenue Sales_quantity Average_cost The_average_annual_payroll_of_the_region
0 01-01-2015 16010072.1195 12729.0 1257.76354148008 30024676.0
1 01-02-2015 15807587.449808 11636.0 1358.50699981162 30024676.0
2 01-03-2015 22047146.023644 15922.0 1384.69702447205 30024676.0
3 01-04-2015 18814583.29428 15227.0 1235.60670481907 30024676.0
4 01-05-2015 14021479.611678 8620.0 1626.62176469582 30024676.0
5 01-06-2015 16783928.522112 13160.0 1275.37450775927 30024676.0
6 01-07-2015 19161892.194872 17254.0 1110.57680508126 30024676.0
7 01-08-2015 15204984.296742 8642.0 1759.4288702548 30024676.0
8 01-09-2015 20603939.9751 16144.0 1276.25990926041 30024676.0
@Nikithakatta30
Nikithakatta30 / temperature.csv
Created May 7, 2023 22:01
timestamp temperature
2015-03-20T21:00:00.000Z 23.9516625615764
2015-03-20T22:00:00.000Z 23.0728888291688
2015-03-20T23:00:00.000Z 22.2708190476318
2015-03-21T00:00:00.000Z 21.3394373423804
2015-03-21T01:00:00.000Z 20.1010743049325
2015-03-21T02:00:00.000Z 18.4150717551479
2015-03-21T03:00:00.000Z 17.7483817583905
2015-03-21T04:00:00.000Z 17.6589726749868
2015-03-21T05:00:00.000Z 17.0922334804965
@Nikithakatta30
Nikithakatta30 / Iris.csv
Created May 7, 2023 21:41
sepal_length sepal_width petal_length petal_width species
5.1 3.5 1.4 0.2 setosa
4.9 3.0 1.4 0.2 setosa
4.7 3.2 1.3 0.2 setosa
4.6 3.1 1.5 0.2 setosa
5.0 3.6 1.4 0.2 setosa
5.4 3.9 1.7 0.4 setosa
4.6 3.4 1.4 0.3 setosa
5.0 3.4 1.5 0.2 setosa
4.4 2.9 1.4 0.2 setosa