Skip to content

Instantly share code, notes, and snippets.

View jandot's full-sized avatar

Jan Aerts jandot

View GitHub Profile
We can't make this file beautiful and searchable because it's too large.
statuut,date,aantal
AAP,2019-06-01,4
AAP,2019-06-02,4
AAP,2019-06-03,4
AAP,2019-06-04,4
AAP,2019-06-05,4
AAP,2019-06-06,4
AAP,2019-06-07,4
AAP,2019-06-08,4
AAP,2019-06-09,4
datum aantal
2019-06-01 82
2019-06-02 82
2019-06-03 82
2019-06-04 82
2019-06-05 82
2019-06-06 82
2019-06-07 82
2019-06-08 82
2019-06-09 82
[
{ "name": "school travel ban to Italy",
"from": "2020-03-06" },
{ "name": "companies advised to adopt telework",
"from": "2020-03-10" },
{ "name": "closure of companies offering non-essential services",
"from": "2020-03-10",
"to": "2020-05-04" },
{ "name": "school closure",
"from": "2020-03-13",
We can't make this file beautiful and searchable because it's too large.
id;wave2;wave3;wave4;wave5;wave6;wave7;wave8;wave9;wave10;wave11
0;1;1;0;0;0;0;0;0;0;0
1;1;1;0;0;0;0;0;0;0;0
2;1;1;0;0;0;0;0;0;0;0
3;1;1;0;0;0;0;0;0;0;0
4;1;1;0;0;0;0;0;0;0;0
5;1;1;0;0;0;0;0;0;0;0
6;1;1;0;0;0;0;0;0;0;0
7;1;1;0;0;0;0;0;0;0;0
8;1;1;0;0;0;0;0;0;0;0
{
"file": "https://gist.githubusercontent.com/jandot/d45196bf8960877d56c3f40c3592b1e9/raw/9d7b16c82a606a8f0a2e4317cb0d421468e514af/upset-data-2000.csv",
"name": "COVID-19 Survey waves",
"header": 0,
"separator": ";",
"skip": 0,
"meta": [
{ "type": "id", "index": 0, "name": "Name" }
],
"sets": [
We can't make this file beautiful and searchable because it's too large.
id;wave2;wave3;wave4;wave5;wave6;wave7;wave8;wave9;wave10;wave11
0;1;1;0;0;0;0;0;0;0;0
1;1;1;0;0;0;0;0;0;0;0
2;1;1;0;0;0;0;0;0;0;0
3;1;1;0;0;0;0;0;0;0;0
4;1;1;0;0;0;0;0;0;0;0
5;1;1;0;0;0;0;0;0;0;0
6;1;1;0;0;0;0;0;0;0;0
7;1;1;0;0;0;0;0;0;0;0
8;1;1;0;0;0;0;0;0;0;0
[
{
"_id" : {
"wave" : 4.0,
"niscode" : 61010
},
"avgWB" : 3.25,
"countWB" : 12.0,
"wave" : 4.0,
"niscode" : 61010
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 7 columns, instead of 5. in line 9.
nis,mean,sd,q1,q2,q3,mode
11001,0.133735174241149,0.00431802081907439,0.125318085854138,0.133711553266769,0.142288548014322,0.133668415895396
11002,0.145047398598384,0.00172540387371603,0.141689906804513,0.14503872689299,0.148455484701813,0.145021373099939
11004,0.134520537232279,0.00436611750444635,0.126030912589877,0.134489925850119,0.143188618047055,0.134433342297455
11005,0.141591526594365,0.00539127501269663,0.131116347842511,0.141551788993418,0.152295218644341,0.141476768887606
11007,0.138849152427928,0.0054493984544749,0.128384478102627,0.138763217932011,0.149807273435913,0.138597451465553
11008,0.132452590138184,0.00388847981894874,0.124922925524131,0.132416666229159,0.140184392154678,0.132346043243302
11009,0.134707965389364,0.00398053877351823,0.126984930674036,0.134675627541911,0.142620410648691,0.134614535343924
11013,0.129652834745636,0.00410239888609421,0.121628341848417,0.129643596968106,0.137730257146536,0.129627822560807
11016,0.131480099086089,0.00688853864247115,0.118304931296838,0.13136346
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 7 columns, instead of 5. in line 9.
nis,mean,sd,q1,q2,q3,mode
11001,0.154305751738077,0.00501538417154882,0.144643093280628,0.154237852417399,0.164355414171089,0.154106834962614
11002,0.166744716191544,0.00196000468604592,0.162930969907508,0.166734579131596,0.170616968919322,0.166714268799417
11004,0.157966291646154,0.00513588234841088,0.148134089048417,0.157875354882176,0.168317810899593,0.157698031572413
11005,0.160422263886525,0.00617327480374066,0.148448487395092,0.160370550205808,0.172697820077738,0.160272260826993
11007,0.15814893793965,0.00626164522241307,0.146108803042603,0.158056491403469,0.170722262982652,0.157878116926608
11008,0.147911913423991,0.00444588632794153,0.139261564823102,0.147885870417474,0.15671162472539,0.147835659116363
11009,0.155944165573929,0.00465977973516513,0.146960937621625,0.155885430692343,0.165265487670249,0.155771671227067
11013,0.148024301497036,0.00471871623344227,0.138815657429609,0.148006615846058,0.157338258329291,0.14797415249518
11016,0.147501729760547,0.0078116115491826,0.132520152680975,0.1473821242
id count wave value
0_0_0_0_0 114 3 0
0_0_0_0_0 114 4 0
0_0_0_0_0 114 5 0
0_0_0_0_0 114 6 0
0_0_0_0_0 114 7 0
0_0_0_0_1 8 3 0
0_0_0_0_1 8 4 0
0_0_0_0_1 8 5 0
0_0_0_0_1 8 6 0