Skip to content

Instantly share code, notes, and snippets.

View cutendorf's full-sized avatar

Christine Utendorf cutendorf

View GitHub Profile
We can't make this file beautiful and searchable because it's too large.
id,ib_var_1,ib_var_2,ib_var_3,ib_var_4,ib_var_5,ib_var_6,ib_var_7,ib_var_8,ib_var_9,ib_var_10,ib_var_11,ib_var_12,ib_var_13,ib_var_14,ib_var_15,ib_var_16,ib_var_17,ib_var_18,ib_var_19,ib_var_20,ib_var_21,icn_var_22,icn_var_23,icn_var_24,ico_var_25,ico_var_26,ico_var_27,ico_var_28,ico_var_29,ico_var_30,ico_var_31,ico_var_32,ico_var_33,ico_var_34,ico_var_35,ico_var_36,ico_var_37,ico_var_38,ico_var_39,ico_var_40,ico_var_41,ico_var_42,ico_var_43,ico_var_44,ico_var_45,ico_var_46,ico_var_47,ico_var_48,ico_var_49,ico_var_50,ico_var_51,ico_var_52,ico_var_53,ico_var_54,ico_var_55,ico_var_56,ico_var_57,ico_var_58,ico_var_59,ico_var_60,ico_var_61,ico_var_62,ico_var_63,ico_var_64,if_var_65,if_var_66,if_var_67,if_var_68,if_var_69,if_var_70,if_var_71,if_var_72,if_var_73,if_var_74,if_var_75,if_var_76,if_var_77,if_var_78,if_var_79,if_var_80,if_var_81
1,0,1,0,0,1,0,0,0,0,0,0,1,0,1,0,0,1,0,1,0,1,2,1,1,4,4,4,4,4,3,4,4,,0,0,0,4,4,2,3,3,4,4,4,2,4,2,4,2,2,2,4,2,4,4,4,2,3,2,2,2,2,3,2,43,100,8,7196,5140,1,4,5,0.774999976,1,10,11,0.6
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 83 columns, instead of 77. in line 1.
id,ib_var_1,ib_var_2,ib_var_3,ib_var_4,ib_var_5,ib_var_6,ib_var_7,ib_var_8,ib_var_9,ib_var_10,ib_var_11,ib_var_12,ib_var_13,ib_var_14,ib_var_15,ib_var_16,ib_var_17,ib_var_18,ib_var_19,ib_var_20,ib_var_21,icn_var_22,icn_var_23,icn_var_24,ico_var_25,ico_var_26,ico_var_27,ico_var_28,ico_var_29,ico_var_30,ico_var_31,ico_var_32,ico_var_33,ico_var_34,ico_var_35,ico_var_36,ico_var_37,ico_var_38,ico_var_39,ico_var_40,ico_var_41,ico_var_42,ico_var_43,ico_var_44,ico_var_45,ico_var_46,ico_var_47,ico_var_48,ico_var_49,ico_var_50,ico_var_51,ico_var_52,ico_var_53,ico_var_54,ico_var_55,ico_var_56,ico_var_57,ico_var_58,ico_var_59,ico_var_60,ico_var_61,ico_var_62,ico_var_63,ico_var_64,if_var_65,if_var_66,if_var_67,if_var_68,if_var_69,if_var_70,if_var_71,if_var_72,if_var_73,if_var_74,if_var_75,if_var_76,if_var_77,if_var_78,if_var_79,if_var_80,if_var_81,ob_target
1,0,1,0,0,1,1,0,0,0,0,0,1,0,1,1,1,0,1,1,1,0,2,1,2,4,4,4,4,5,4,4,3,11,15,7,14,3,3,1,3,4,1,3,4,4,4,4,4,2,1,3,3,2,4,2,3,1,4,3,3,2,4,3,1,31,100,6,4626,7196,1,6,6,0.8,0,6,5
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
userID;placeID;rating;Friends
U1077;135085;3;Group1
U1077;135038;3;Group1
U1077;132825;3;Group1
U1077;135060;2;Group1
U1068;135104;2;Group1
U1068;132740;1;Group1
U1068;132663;2;Group1
U1068;132732;1;Group1
U1068;132630;2;Group1
userID;placeID;rating
U1077;135085;3
U1077;135038;3
U1077;132825;3
U1077;135060;2
U1068;135104;2
U1068;132740;1
U1068;132663;2
U1068;132732;1
U1068;132630;2
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
userID;Friends
U1077;Group1
U1068;Group1
U1067;Group1
U1103;Group1
U1107;Group1
U1044;Group1
U1070;Group1
U1031;Group1
U1082;Group1
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
userID;placeID;rating;Friends
U1077;135085;2;Group1
U1077;135038;2;Group1
U1077;132825;2;Group1
U1077;135060;1;Group1
U1068;135104;1;Group1
U1068;132740;0;Group1
U1068;132663;1;Group1
U1068;132732;0;Group1
U1068;132630;1;Group1
userID,placeID,rating,food_rating,service_rating
U1077,135085,2,2,2
U1077,135038,2,2,1
U1077,132825,2,2,2
U1077,135060,1,2,2
U1068,135104,1,1,2
U1068,132740,0,0,0
U1068,132663,1,1,1
U1068,132732,0,0,0
U1068,132630,1,1,1
We can't make this file beautiful and searchable because it's too large.
id,amount_tsh,date_recorded,funder,gps_height,installer,longitude,latitude,wpt_name,num_private,basin,subvillage,region,region_code,district_code,lga,ward,population,public_meeting,recorded_by,scheme_management,scheme_name,permit,construction_year,extraction_type,extraction_type_group,extraction_type_class,management,management_group,payment,payment_type,water_quality,quality_group,quantity,quantity_group,source,source_type,source_class,waterpoint_type,waterpoint_type_group
50785,0,04/02/13,Dmdd,1996,DMDD,35.2907992,-4.05969643,Dinamu Secondary School,0,Internal,Magoma,Manyara,21,3,Mbulu,Bashay,321,TRUE,GeoData Consultants Ltd,Parastatal,,TRUE,2012,other,other,other,parastatal,parastatal,never pay,never pay,soft,good,seasonal,seasonal,rainwater harvesting,rainwater harvesting,surface,other,other
51630,0,04/02/13,Government Of Tanzania,1569,DWE,36.65670893,-3.30921425,Kimnyak,0,Pangani,Kimnyak,Arusha,2,2,Arusha Rural,Kimnyaki,300,TRUE,GeoData Consultants Ltd,VWC,TPRI pipe line,TRUE,2000,gravity,gravity,gravity
type;entity;disb_amt;disb_type;cont_amt;trump_related
Person;AARON SCHOCK;;;;
Person;ABDUL WAHID AL ULAMA;;;;
Person;ABE WALLACH;;;;
Person;AJIT PAI;;;;
Person;ALAN GARTEN;29564;LEGAL FILING FEE;14100;
Person;ALAN HAMMER;;;;
Person;ALAN JOHN ROGERS;;;;
Person;ALBERT ROSS SR.;;;;
Person;ALEX SHNAIDER;;;;
type;entity;disb_amt;disb_type;cont_amt;trump_related
Person;AARON SCHOCK;;;;
Person;ABDUL WAHID AL ULAMA;;;;
Person;ABE WALLACH;;;;
Person;AJIT PAI;;;;
Person;ALAN GARTEN;29564;LEGAL FILING FEE;14100;
Person;ALAN HAMMER;;;;
Person;ALAN JOHN ROGERS;;;;
Person;ALBERT ROSS SR.;;;;
Person;ALEX SHNAIDER;;;;