Skip to content

Instantly share code, notes, and snippets.

View rutgerhofste's full-sized avatar

Rutger Hofste rutgerhofste

  • WRI
  • Washington DC
View GitHub Profile
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Simple Chart</title>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<style>
canvas {
margin-top: 30px;
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 40 columns, instead of 20 in line 3.
doy,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019
1,0,0,0,2.054361521,8.419297357,0,0,0.196125639,0,3.156129305,5.882610138,5.536418288,0,0,13.1081503,0.279442414,0.013112066,0,0.009001094,0.209941065,0.068736441,0,0,2.210026518,0.111261044,0,0,0,0,0,0,10.14940479,4.693093232,4.287277116,3.046706289,1.264636834,2.907586017,5.161891566,0
2,0,0,0,4.592891856,15.8742555,0,0,5.738429975,0,3.156129305,10.21767472,6.230765639,0.042719697,0,15.32623742,1.16387467,0.331763624,0.043245224,0.009001094,0.209941065,0.128119703,0,0.443420382,2.221262015,0.115764399,0.0150457,0,0,0,2.171839603,1.941218697,15.10511269,4.693093232,4.376128302,3.183847033,1.519362305,4.343652278,5.188236645,1.039875376
3,0,0.361742687,0.190689932,4.592891856,16.14786958,0,0,5.746300543,0,3.178700773,13.40608347,9.40666216,0.049600321,2.962094568,15.32623742,1.16387467,0.331763624,0.06391966,0.111
integer label
0 Animal
1 Archway
2 Bicyclist
3 Bridge
4 Building
5 Car
6 CartLuggagePram
7 Child
8 Column_Pole
We can't make this file beautiful and searchable because it's too large.
int64_field_0,pfafid_30spfaf06,temporal_resolution,year,month,area_m2_30spfaf06,area_count_30spfaf06,ptotww_m_30spfaf06,ptotwn_m_30spfaf06,pdomww_m_30spfaf06,pdomwn_m_30spfaf06,pindww_m_30spfaf06,pindwn_m_30spfaf06,pirrww_m_30spfaf06,pirrwn_m_30spfaf06,plivww_m_30spfaf06,plivwn_m_30spfaf06,riverdischarge_m_30spfaf06,ma10_ptotww_m_30spfaf06,ma10_ptotwn_m_30spfaf06,ma10_pdomww_m_30spfaf06,ma10_pdomwn_m_30spfaf06,ma10_pindww_m_30spfaf06,ma10_pindwn_m_30spfaf06,ma10_pirrww_m_30spfaf06,ma10_pirrwn_m_30spfaf06,ma10_plivww_m_30spfaf06,ma10_plivwn_m_30spfaf06,ma10_riverdischarge_m_30spfaf06,min10_ptotww_m_30spfaf06,min10_ptotwn_m_30spfaf06,min10_pdomww_m_30spfaf06,min10_pdomwn_m_30spfaf06,min10_pindww_m_30spfaf06,min10_pindwn_m_30spfaf06,min10_pirrww_m_30spfaf06,min10_pirrwn_m_30spfaf06,min10_plivww_m_30spfaf06,min10_plivwn_m_30spfaf06,min10_riverdischarge_m_30spfaf06,max10_ptotww_m_30spfaf06,max10_ptotwn_m_30spfaf06,max10_pdomww_m_30spfaf06,max10_pdomwn_m_30spfaf06,max10_pindww_m_30spfaf06,max10_pindwn_m_30spfaf06,m
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 40 columns, instead of 20 in line 3.
doy,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019
1,0,0,0,2.054361521,8.419297357,0,0,0.196125639,0,3.156129305,5.882610138,5.536418288,0,0,13.1081503,0.279442414,0.013112066,0,0.009001094,0.209941065,0.068736441,0,0,2.210026518,0.111261044,0,0,0,0,0,0,10.14940479,4.693093232,4.287277116,3.046706289,1.264636834,2.907586017,5.161891566,0
2,0,0,0,4.592891856,15.8742555,0,0,5.738429975,0,3.156129305,10.21767472,6.230765639,0.042719697,0,15.32623742,1.16387467,0.331763624,0.043245224,0.009001094,0.209941065,0.128119703,0,0.443420382,2.221262015,0.115764399,0.0150457,0,0,0,2.171839603,1.941218697,15.10511269,4.693093232,4.376128302,3.183847033,1.519362305,4.343652278,5.188236645,1.039875376
3,0,0.361742687,0.190689932,4.592891856,16.14786958,0,0,5.746300543,0,3.178700773,13.40608347,9.40666216,0.049600321,2.962094568,15.32623742,1.16387467,0.331763624,0.06391966,0.111
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 40 columns, instead of 31 in line 2.
dayofyear,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019
1,1.480330512,2.793618662,2.406307453,7.347986741,8.940525147,4.176921844,2.526860476,2.280632492,7.021742388,4.867977188,7.843544556,3.51459728,2.085447555,2.441190588,9.346102846,2.551887896,3.86302963,1.775953473,2.994755248,2.41926193,2.08842335,7.070227207,2.263064725,3.951957345,2.21285154,2.572686646,2.152149275,3.981434269,4.301088885,2.846923767,7.934326535,8.772714168,1.968872577,2.279577898,2.773446393,2.267968844,2.952547192,2.467595253,2.636406137
6,3.002461915,4.958106722,4.1640819,11.98915654,11.23016054,7.635143145,4.899311502,4.08726464,15.35203131,8.945329365,10.71868857,5.394065525,3.645456647,4.432518638,15.48630894,5.19587659,9.091153033,2.363738715,5.295967277,4.517586631,3.783647159,10.27984572,3.993540897,6.84410369,6.24773649,5.353579097,3.794264349,5.904076742,8.820615783,6.61990414
@rutgerhofste
rutgerhofste / example.csv
Created May 3, 2019 18:33
histogram bigquery
We can't make this file beautiful and searchable because it's too large.
system:index,COUNTYFP,LST_Day_1km,Land_Cover_Type_1,NAME,STATEFP,sur_refl_b01,sur_refl_b02,sur_refl_b03,sur_refl_b04,sur_refl_b05,sur_refl_b06,sur_refl_b07,.geo
00005b20f5ee97c47684,031,"[[0.0, 4.0], [8.0, 0.0], [16.0, 0.0], [24.0, 0.0], [32.0, 0.0], [40.0, 0.0], [48.0, 0.0], [56.0, 0.0], [64.0, 1.0], [72.0, 1.0], [80.0, 4.0], [88.0, 0.0], [96.0, 0.0], [104.0, 0.0], [112.0, 0.0], [120.0, 0.0], [128.0, 0.0], [136.0, 0.0], [144.0, 0.0], [152.0, 0.0], [160.0, 0.0], [168.0, 0.0], [176.0, 0.0], [184.0, 0.0], [192.0, 0.0], [200.0, 0.0], [208.0, 0.0], [216.0, 0.0], [224.0, 0.0], [232.0, 0.0], [240.0, 0.0], [248.0, 0.0]]","[[0.0, 0.0], [8.0, 10.0], [16.0, 0.0], [24.0, 0.0], [32.0, 0.0], [40.0, 0.0], [48.0, 0.0], [56.0, 0.0], [64.0, 0.0], [72.0, 0.0], [80.0, 0.0], [88.0, 0.0], [96.0, 0.0], [104.0, 0.0], [112.0, 0.0], [120.0, 0.0], [128.0, 0.0], [136.0, 0.0], [144.0, 0.0], [152.0, 0.0], [160.0, 0.0], [168.0, 0.0], [176.0, 0.0], [184.0, 0.0], [192.0, 0.0], [200.0, 0.0], [208.0, 0.0], [216.0, 0.0], [224.0, 0.0], [232.0,
NAME_1 VARNAME_1 STATE_FIPS
Arkansas AR 5
Illinois IL 17
Indiana IN 18
Iowa IA 19
Kansas KS 20
Minnesota MN 27
Missouri MO 29
Nebraska NE 31
North Dakota ND 38
@rutgerhofste
rutgerhofste / complete_v02.csv
Last active May 3, 2019 12:00
make_it_rain_soybean_yield
We can't make this file beautiful and searchable because it's too large.
year,STATEFP,COUNTYFP,YIELD_SOYBEAN_BUSHELPERACRE,UNIQUE_ID,STATE,COUNTY
2009,1,1,30,STATE_1_COUNTY_1,AL,Autauga County
2010,1,1,16.9,STATE_1_COUNTY_1,AL,Autauga County
2011,1,1,26,STATE_1_COUNTY_1,AL,Autauga County
2013,1,1,41.2,STATE_1_COUNTY_1,AL,Autauga County
2016,1,1,0,STATE_1_COUNTY_1,AL,Autauga County
2003,5,1,45,STATE_5_COUNTY_1,AR,Arkansas County
2004,5,1,46,STATE_5_COUNTY_1,AR,Arkansas County
2005,5,1,41,STATE_5_COUNTY_1,AR,Arkansas County
2006,5,1,46,STATE_5_COUNTY_1,AR,Arkansas County
This file has been truncated, but you can view the full file.
62 Another Development - AD Sanchaung, Yangon 11111 MM
MOOSMATTENSTR. 25,79117 FREIBURG
19555 ,Shoemakersville, PA
Vintergatan 50, Skelleftehamn
110 W Tehachapi Blvd Tehachapi, CA 93561-1632, United States
UHRLAUBSTR. 9,31582 NIENBURG
locate=0 Hwy 29 North, Danielsville, GA 30633, US
AVENWEDDER STR. 55,33335 G�TERSLOH
IM LERCHENRAIN 3,74626 BRETZFELD
LUBLIN, UL. SEKUTOWICZA 35 35A, DIEGO PIZZA