Skip to content

Instantly share code, notes, and snippets.

View pbeens's full-sized avatar

Peter Beens pbeens

19 followers · 21 following
View GitHub Profile
@pbeens
pbeens / ll21ddc2021-7.py
Created February 23, 2021 14:52
Lighthouse Labs 21 Day Data Challenge 2021 #7
# Sort the boxes by weight
# https://data-challenge.lighthouselabs.ca/challenge/7
import pandas as pd
user_boxes = {'weight': [4,2,18,21,14,13],
'box_name': ['box1','box2', 'box3', 'box4', 'box5', 'box6']
}
def boxes_sorted_by_weight(b):
@pbeens
pbeens / LL-21DDC2021-milk_2.csv
Last active February 25, 2021 16:57
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #9. Save locally as "milk_2.csv.
Month Monthly milk production: pounds per cow Number of Cows
07-Feb 589 30
07-Mar 561 32
07-Apr 640 35
07-May 656 35
07-Jun 727 35
07-Jul 697 35
07-Aug 640 35
07-Sep 599 35
07-Oct 568 35
@pbeens
pbeens / LL-21DDC2021-milk_32.csv
Last active February 26, 2021 16:43
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #10. Save locally as "milk_32.csv.
Month Monthly milk production: pounds per cow Number of Cows Total Milk Production Price_Per_Pound Total Revenue
0 07-Feb 589 30 0.22
1 07-Mar 561 32 0.22
2 07-Apr 640 35 0.22
3 07-May 656 35 0.22
4 07-Jun 727 35 0.22
5 07-Jul 697 35 0.22
6 07-Aug 640 35 0.22
7 07-Sep 599 35 0.22
8 07-Oct 568 35 0.22
@pbeens
pbeens / LL-21DDC2021-avacado.csv
Created February 27, 2021 13:52
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #11. Save locally as "avacodo.csv.
We can't make this file beautiful and searchable because it's too large.
,Date,AveragePrice,Total Volume,Total Bags,Small Bags,Large Bags,XLarge Bags,type,year,region
0,2015-12-27,1.33,64236.62,8696.87,8603.62,93.25,0,conventional,2015,Albany
1,2015-12-20,1.35,54876.98,9505.56,9408.07,97.49,0,conventional,2015,Albany
2,2015-12-13,0.93,118220.22,8145.35,8042.21,103.14,0,conventional,2015,Albany
3,2015-12-06,1.08,78992.15,5811.16,5677.4,133.76,0,conventional,2015,Albany
4,2015-11-29,1.28,51039.6,6183.95,5986.26,197.69,0,conventional,2015,Albany
5,2015-11-22,1.26,55979.78,6683.91,6556.47,127.44,0,conventional,2015,Albany
6,2015-11-15,0.99,83453.76,8318.86,8196.81,122.05,0,conventional,2015,Albany
7,2015-11-08,0.98,109428.33,6829.22,6266.85,562.37,0,conventional,2015,Albany
8,2015-11-01,1.02,99811.42,11388.36,11104.53,283.83,0,conventional,2015,Albany
@pbeens
pbeens / LL-21DDC2021-winequality-red.csv
Created March 1, 2021 17:03
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #13. Save locally as "winequality-red.csv".
fixed acidity volatile acidity citric acid residual sugar chlorides free sulfur dioxide total sulfur dioxide density pH sulphates alcohol quality
7.4 0.7 0.0 1.9 0.076 11.0 34.0 0.9978 3.51 0.56 9.4 5
7.8 0.88 0.0 2.6 0.098 25.0 67.0 0.9968 3.2 0.68 9.8 5
7.8 0.76 0.04 2.3 0.092 15.0 54.0 0.997 3.26 0.65 9.8 5
11.2 0.28 0.56 1.9 0.075 17.0 60.0 0.998 3.16 0.58 9.8 6
7.4 0.7 0.0 1.9 0.076 11.0 34.0 0.9978 3.51 0.56 9.4 5
7.4 0.66 0.0 1.8 0.075 13.0 40.0 0.9978 3.51 0.56 9.4 5
7.9 0.6 0.06 1.6 0.069 15.0 59.0 0.9964 3.3 0.46 9.4 5
7.3 0.65 0.0 1.2 0.065 15.0 21.0 0.9946 3.39 0.47 10.0 7
7.8 0.58 0.02 2.0 0.073 9.0 18.0 0.9968 3.36 0.57 9.5 7
@pbeens
pbeens / LL-21DDC2021-winequality-red_2.csv
Created March 3, 2021 00:01
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #14. If using locally, save as "winequality-red_2.csv".
fixed acidity volatile acidity citric acid residual sugar chlorides free sulfur dioxide total sulfur dioxide density pH sulphates alcohol quality region price
0 7.4 0.7 0.0 1.9 0.076 11.0 34.0 0.9978 3.51 0.56 9.4 5 Colchagua Valley 64
1 7.8 0.88 0.0 2.6 0.098 25.0 67.0 0.9968 3.2 0.68 9.8 5 Bordeaux 89
2 7.8 0.76 0.04 2.3 0.092 15.0 54.0 0.997 3.26 0.65 9.8 5 La Rjoja 25
3 11.2 0.28 0.56 1.9 0.075 17.0 60.0 0.998 3.16 0.58 9.8 6 Willamette 27
4 7.4 0.7 0.0 1.9 0.076 11.0 34.0 0.9978 3.51 0.56 9.4 5 Marlborough 9
5 7.4 0.66 0.0 1.8 0.075 13.0 40.0 0.9978 3.51 0.56 9.4 5 Okanagan Valley 10
6 7.9 0.6 0.06 1.6 0.069 15.0 59.0 0.9964 3.3 0.46 9.4 5 Colchagua Valley 111
7 7.3 0.65 0.0 1.2 0.065 15.0 21.0 0.9946 3.39 0.47 10.0 7 Bordeaux 9
8 7.8 0.58 0.02 2.0 0.073 9.0 18.0 0.9968 3.36 0.57 9.5 7 La Rjoja 70
@pbeens
pbeens / LL-21DDC2021-boardgames.csv
Created March 7, 2021 00:43
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #18. If using locally, save as "boardgames.csv".
We can't make this file beautiful and searchable because it's too large.
rank,bgg_url,game_id,names,min_players,max_players,avg_time,min_time,max_time,year,avg_rating,geek_rating,num_votes,image_url,age,mechanic,owned,category,designer,weight
1,https://boardgamegeek.com/boardgame/174430/gloomhaven,174430,Gloomhaven,1,4,120,60,120,2017,8.98893,8.61858,15376,https://cf.geekdo-images.com/original/img/lDN358RgcYvQfYYN6Oy2TXpifyM=/0x0/pic2437871.jpg,12,"Action / Movement Programming, Co-operative Play, Grid Movement, Hand Management, Modular Board, Role Playing, Simultaneous Action Selection, Storytelling, Variable Player Powers",25928,"Adventure, Exploration, Fantasy, Fighting, Miniatures",Isaac Childres,3.7543
2,https://boardgamegeek.com/boardgame/161936/pandemic-legacy-season-1,161936,Pandemic Legacy: Season 1,2,4,60,60,60,2015,8.6614,8.50163,26063,https://cf.geekdo-images.com/original/img/P_SwsOtPLqgk2ScCgI2YrI9Rg6I=/0x0/pic2452831.png,13,"Action Point Allowance System, Co-operative Play, Hand Management, Point to Point Movement, Set Collection, Trading, Variable Player Powers",416
@pbeens
pbeens / LL-21DDC2021-video_games.csv
Created March 9, 2021 15:18
This data file is from the Lighthouse Labs 21 Day Data Challenge (2021), challenge #21. If using locally, save as "video_games.csv".
We can't make this file beautiful and searchable because it's too large.
Name,Platform,Year_of_Release,Genre,Publisher,NA_Sales,EU_Sales,JP_Sales,Other_Sales,Global_Sales,Critic_Score,Critic_Count,User_Score,User_Count,Developer,Rating
Wii Sports,Wii,2006.0,Sports,Nintendo,41.36,28.96,3.77,8.45,82.53,76.0,51.0,8.0,322.0,Nintendo,E
Super Mario Bros.,NES,1985.0,Platform,Nintendo,29.08,3.58,6.81,0.77,40.24,,,7.5,,,
Mario Kart Wii,Wii,2008.0,Racing,Nintendo,15.68,12.76,3.79,3.29,35.52,82.0,73.0,8.3,709.0,Nintendo,E
Wii Sports Resort,Wii,2009.0,Sports,Nintendo,15.61,10.93,3.28,2.95,32.77,80.0,73.0,8.0,192.0,Nintendo,E
Pokemon Red/Pokemon Blue,GB,1996.0,Role-Playing,Nintendo,11.27,8.89,10.22,1.0,31.37,,,7.5,,,
Tetris,GB,1989.0,Puzzle,Nintendo,23.2,2.26,4.22,0.58,30.26,,,7.5,,,
New Super Mario Bros.,DS,2006.0,Platform,Nintendo,11.28,9.14,6.5,2.88,29.8,89.0,65.0,8.5,431.0,Nintendo,E
Wii Play,Wii,2006.0,Misc,Nintendo,13.96,9.18,2.93,2.84,28.92,58.0,41.0,6.6,129.0,Nintendo,E
New Super Mario Bros. Wii,Wii,2009.0,Platform,Nintendo,14.44,6.94,4.7,2.24,28.32,87.0,80.0,8.4,594.0,Nintendo,E
@pbeens
pbeens / mpg.csv
Created March 13, 2021 03:41
CSV file used in Coursera's Introduction to Data Science with Python course.
manufacturer model displ year cyl trans drv cty hwy fl class
1 audi a4 1.8 1999 4 auto(l5) f 18 29 p compact
2 audi a4 1.8 1999 4 manual(m5) f 21 29 p compact
3 audi a4 2 2008 4 manual(m6) f 20 31 p compact
4 audi a4 2 2008 4 auto(av) f 21 30 p compact
5 audi a4 2.8 1999 6 auto(l5) f 16 26 p compact
6 audi a4 2.8 1999 6 manual(m5) f 18 26 p compact
7 audi a4 3.1 2008 6 auto(av) f 18 27 p compact
8 audi a4 quattro 1.8 1999 4 manual(m5) 4 18 26 p compact
9 audi a4 quattro 1.8 1999 4 auto(l5) 4 16 25 p compact
@pbeens
pbeens / square-numbers-1-100.csv
Last active March 24, 2021 02:31
Square numbers from 1 to 100
X Y
1 1
2 4
3 9
4 16
5 25
6 36
7 49
8 64
9 81