Skip to content

Instantly share code, notes, and snippets.

@sallen927
sallen927 / ClientsServed.csv
Created May 6, 2015 20:49
Module 6-Participants vs. Clients Served Line Series
year clientsserved
2010 296
2011 553
2012 2469
2013 3003
2014 2789
2015 2211
@sallen927
sallen927 / ClientsServed.csv
Created April 27, 2015 06:14
Help! only getting 1 line on time series chart
2010 296
2011 553
2012 2469
2013 3003
2014 2789
2015 2211
@sallen927
sallen927 / ClientsServed.csv
Created April 26, 2015 23:12
Question-Lines not showing up
2010 296
2011 553
2012 2469
2013 3003
2014 2789
2015 2211
@sallen927
sallen927 / School Lunch Programs By State_2009-2012 CSV1.csv
Created April 23, 2015 01:28
Scatterplot-WIC Participants and School Lunch
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 24 columns, instead of 15. in line 2.
State,WICparticipantsFY2009,WICparticipantsFY2011,"WICparticipants,FY2012",WICParticipants,NationalSchoolLunchProgramparticipantsFY2009,NationalSchoolLunchProgramparticipantsFY2011,"NationalSchoolLunchProgramparticipants,FY2012",SchoolBreakfastProgramparticipantsFY2009,SchoolBreakfastProgramparticipantsFY2011,"SchoolBreakfastProgramparticipants,FY2012",ChildandAdultCareparticpantsFY2009,ChildandAdultCareparticpantsFY2011,"ChildandAdultCareparticipants,FY2012",SummerFoodparticpantsFY2009,SummerFoodparticipantsFY2011,"SummerFoodparticipants,FY2012","StatePopulation,2008","StatePopulation,2009","StatePopulation,2010","StatePopulation,2011","StatePopulation,2012","StatePopulation,2013",
Alabama,"140,810","143,768","141,900",142,571,"571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722,
Alaska,"25,816","26,295","24,969",25,54,"54,410","53,920","16,943","19,974","20,759","9,874","9,616","10,541","2,345"
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 24 columns, instead of 15. in line 2.
State,WICparticipantsFY2009,WICparticipantsFY2011,"WICparticipants,FY2012",WICParticipants,NationalSchoolLunchProgramparticipantsFY2009,NationalSchoolLunchProgramparticipantsFY2011,"NationalSchoolLunchProgramparticipants,FY2012",SchoolBreakfastProgramparticipantsFY2009,SchoolBreakfastProgramparticipantsFY2011,"SchoolBreakfastProgramparticipants,FY2012",ChildandAdultCareparticpantsFY2009,ChildandAdultCareparticpantsFY2011,"ChildandAdultCareparticipants,FY2012",SummerFoodparticpantsFY2009,SummerFoodparticipantsFY2011,"SummerFoodparticipants,FY2012","StatePopulation,2008","StatePopulation,2009","StatePopulation,2010","StatePopulation,2011","StatePopulation,2012","StatePopulation,2013",
Alabama,"140,810","143,768","141,900",142,571,"571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722,
Alaska,"25,816","26,295","24,969",25,54,"54,410","53,920","16,943","19,974","20,759","9,874","9,616","10,541","2,345"
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
State,WICparticipantsFY2009,WICparticipantsFY2011,"WICparticipants,FY2012",WICParticipants,NationalSchoolLunchProgramparticipantsFY2009,NationalSchoolLunchProgramparticipantsFY2011,"NationalSchoolLunchProgramparticipants,FY2012",SchoolBreakfastProgramparticipantsFY2009,SchoolBreakfastProgramparticipantsFY2011,"SchoolBreakfastProgramparticipants,FY2012",ChildandAdultCareparticpantsFY2009,ChildandAdultCareparticpantsFY2011,"ChildandAdultCareparticipants,FY2012",SummerFoodparticpantsFY2009,SummerFoodparticipantsFY2011,"SummerFoodparticipants,FY2012","StatePopulation,2008","StatePopulation,2009","StatePopulation,2010","StatePopulation,2011","StatePopulation,2012","StatePopulation,2013"
Alabama,"140,810","143,768","141,900",142,"579,880","571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722
Alaska,"25,816","26,295","24,969",25,"53,554","54,410","53,920","16,943","19,974","20,759","9,874","9,616","10,54
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
State,WICparticipantsFY2009,WICparticipantsFY2011,"WICparticipants,FY2012",WICParticipants,NationalSchoolLunchProgramparticipantsFY2009,NationalSchoolLunchProgramparticipantsFY2011,"NationalSchoolLunchProgramparticipants,FY2012",SchoolBreakfastProgramparticipantsFY2009,SchoolBreakfastProgramparticipantsFY2011,"SchoolBreakfastProgramparticipants,FY2012",ChildandAdultCareparticpantsFY2009,ChildandAdultCareparticpantsFY2011,"ChildandAdultCareparticipants,FY2012",SummerFoodparticpantsFY2009,SummerFoodparticipantsFY2011,"SummerFoodparticipants,FY2012","StatePopulation,2008","StatePopulation,2009","StatePopulation,2010","StatePopulation,2011","StatePopulation,2012","StatePopulation,2013"
Alabama,"140,810","143,768","141,900",142,"579,880","571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722
Alaska,"25,816","26,295","24,969",25,"53,554","54,410","53,920","16,943","19,974","20,759","9,874","9,616","10,54
@sallen927
sallen927 / index.csv
Created April 11, 2015 05:12
WIC Participants
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
State,WICparticipantsFY2009,WICparticipantsFY2011,"WICparticipants,FY2012",WICParticipants,NationalSchoolLunchProgramparticipantsFY2009,NationalSchoolLunchProgramparticipantsFY2011,"NationalSchoolLunchProgramparticipants,FY2012",SchoolBreakfastProgramparticipantsFY2009,SchoolBreakfastProgramparticipantsFY2011,"SchoolBreakfastProgramparticipants,FY2012",ChildandAdultCareparticpantsFY2009,ChildandAdultCareparticpantsFY2011,"ChildandAdultCareparticipants,FY2012",SummerFoodparticpantsFY2009,SummerFoodparticipantsFY2011,"SummerFoodparticipants,FY2012","StatePopulation,2008","StatePopulation,2009","StatePopulation,2010","StatePopulation,2011","StatePopulation,2012","StatePopulation,2013"
Alabama,"140,810","143,768","141,900",142,"579,880","571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722
Alaska,"25,816","26,295","24,969",25,"53,554","54,410","53,920","16,943","19,974","20,759","9,874","9,616","10,54
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
State   ,WIC participants FY 2009,WIC participants FY 2011,"WIC participants, FY 2012",National School Lunch Program participants FY 2009,National School Lunch Program participants FY 2011,"National School Lunch Program participants, FY 2012",School Breakfast Program participants FY 2009,School Breakfast Program participants FY 2011,"School Breakfast Program participants, FY 2012",Child and Adult Care particpants FY 2009,Child and Adult Care particpants FY 2011,"Child and Adult Care participants, FY 2012",Summer Food particpants FY 2009,Summer Food participants FY 2011,"Summer Food participants, FY 2012","State Population, 2008","State Population, 2009","State Population, 2010","State Population, 2011","State Population, 2012","State Population, 2013"
Alabama,"140,810","143,768","141,900","579,880","571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722
Alaska,"25,816","26,295","24,969","53,554","
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
State   ,WIC participants FY 2009,WIC participants FY 2011,"WIC participants, FY 2012",National School Lunch Program participants FY 2009,National School Lunch Program participants FY 2011,"National School Lunch Program participants, FY 2012",School Breakfast Program participants FY 2009,School Breakfast Program participants FY 2011,"School Breakfast Program participants, FY 2012",Child and Adult Care particpants FY 2009,Child and Adult Care particpants FY 2011,"Child and Adult Care participants, FY 2012",Summer Food particpants FY 2009,Summer Food participants FY 2011,"Summer Food participants, FY 2012","State Population, 2008","State Population, 2009","State Population, 2010","State Population, 2011","State Population, 2012","State Population, 2013"
Alabama,"140,810","143,768","141,900","579,880","571,291","562,959","212,316","216,714","224,496","43,136","42,774","42,933","26,599","24,724","26,423","4,677,464","4,708,708","4,785,401","4,802,740",4817528,4833722
Alaska,"25,816","26,295","24,969","53,554","