Kyle Willett willettk

## bridle_trails.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                willettk
                / bridle_trails.ipynb
            
            
              Created
              January 6, 2019 23:32
            
              
                Bridle Trails 50K predictions
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## names.txt
Bethilda
Brunhilda
Chegory
Chelizabeth
Drusilla
Elizanthonius
Esteñabeth
Festerling
Flimshaw
Grasputin

## nationwide.ipynb

      
              1 file
            
          
              1 fork
            
          
              1 comment
            
          
              1 star
            
          
                willettk
                / nationwide.ipynb
            
            
              Last active
              February 4, 2020 20:01
            
              
                Make a list of all the (English) Wikipedia page titles that can be sung to the tune of the Nationwide jingle.
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## ll70.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                willettk
                / ll70.ipynb
            
            
              Created
              November 10, 2016 15:19
            
              
                LL70 prelims
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## movie_rating_query_extras.sql
-- Q1

SELECT name from Reviewer
WHERE Reviewer.rID IN
(SELECT Rating.rID from Rating
WHERE Rating.mID =
(SELECT mid from Movie
WHERE title = "Gone with the Wind"))

-- Q2

## movie_rating_exercises.sql
-- Q1

SELECT title FROM Movie
WHERE director="Steven Spielberg"

-- Q2

SELECT DISTINCT(year) FROM Movie
JOIN Rating as R on Movie.mID = R.mID
WHERE R.stars > 3 AND R.stars < 6

## Count number of files in sub-directories
find . -maxdepth 1 -mindepth 1 -type d -exec sh -c 'echo "{} : $(find "{}" -type f | wc -l)" file\(s\)' \;

## thesisbeers.py
from matplotlib import pyplot as plt
import numpy as np

pages = np.arange(500)+1

gt = pages / 10.
py = 2.5 * np.log10(pages)

fig = plt.figure(figsize=(8,8))
ax = fig.add_subplot(111)

## oscar_winners.csv
Emil Jannings
Janet Gaynor
Warner Baxter
Mary Pickford
George Arliss
Norma Shearer
Lionel Barrymore
Marie Dressler
Wallace Beery
Fredric March

## mosaic_data.csv

          
            1
            0
            1
            1

            
              1
              0
              1
              1

            
              1
              0
              1
              1

            
              1
              0
              1
              1

            
              1
              1
              0
              0

            
              1
              1
              1
              0

            
              1
              1
              1
              0

            
              1
              1
              1
              0

            
              1
              1
              1
              1

            
              1
              1
              1
              1
	Bethilda
	Brunhilda
	Chegory
	Chelizabeth
	Drusilla
	Elizanthonius
	Esteñabeth
	Festerling
	Flimshaw
	Grasputin
	-- Q1

	SELECT name from Reviewer
	WHERE Reviewer.rID IN
	(SELECT Rating.rID from Rating
	WHERE Rating.mID =
	(SELECT mid from Movie
	WHERE title = "Gone with the Wind"))

	-- Q2
	-- Q1

	SELECT title FROM Movie
	WHERE director="Steven Spielberg"

	-- Q2

	SELECT DISTINCT(year) FROM Movie
	JOIN Rating as R on Movie.mID = R.mID
	WHERE R.stars > 3 AND R.stars < 6
	from matplotlib import pyplot as plt
	import numpy as np

	pages = np.arange(500)+1

	gt = pages / 10.
	py = 2.5 * np.log10(pages)

	fig = plt.figure(figsize=(8,8))
	ax = fig.add_subplot(111)
	Emil Jannings
	Janet Gaynor
	Warner Baxter
	Mary Pickford
	George Arliss
	Norma Shearer
	Lionel Barrymore
	Marie Dressler
	Wallace Beery
	Fredric March