The article to be analyzed in this file is a file on the fight songs of colleges and universities across the US. This includes characteristics such as the school, writers and attributes about the song.
https://projects.fivethirtyeight.com/college-fight-song-lyrics/
library (readr)
library(RCurl)
x <- getURL("https://raw.githubusercontent.com/agersowitz/Data-607-Datasets/master/fight-songs.csv")
fightsongs <- read.csv(text=x)
#print(fightsongs)
rawfsdf <- data.frame(fightsongs)
fightsongdf = rawfsdf[c("school","song_name","year","writers"
,"student_writer","official_song","bpm","sec_duration","fight"
,"number_fights","victory","win_won"
,"victory_win_won","rah","nonsense","colors"
,"men","opponents","spelling","trope_count"
)]
print(fightsongdf)## school song_name
## 1 Notre Dame Victory March
## 2 Baylor Old Fight
## 3 Iowa State Iowa State Fights
## 4 Kansas I'm a Jayhawk
## 5 Kansas State Wildcat Victory
## 6 Oklahoma Boomer Sooner
## 7 Oklahoma State Ride 'Em Cowboys
## 8 Texas Texas Fight
## 9 TCU TCU Fight Song
## 10 Texas Tech Fight, Raiders, Fight
## 11 West Virginia Hail West Virginia
## 12 Illinois Oskee-Wow-Wow
## 13 Indiana Indiana, Our Indiana
## 14 Iowa Iowa Fight Song
## 15 Maryland Maryland Fight Song
## 16 Michigan The Victors
## 17 Michigan State Victory for MSU
## 18 Minnesota The Minnesota Rouser
## 19 Nebraska Dear Old Nebraska U.
## 20 Northwestern Go! U Northwestern
## 21 Ohio State Buckeye Battle Cry
## 22 Penn State Fight On, State
## 23 Purdue Hail Purdue
## 24 Rutgers The Bells Must Ring
## 25 Wisconsin On, Wisconsin
## 26 Arizona Bear Down, Arizona
## 27 Arizona State Maroon and Gold
## 28 California Fight for California
## 29 Colorado Fight CU
## 30 Oregon Mighty Oregon
## 31 Oregon State Hail to Old OSU
## 32 Stanford Come Join the Band
## 33 UCLA Sons of Westwood
## 34 USC Fight On, USC
## 35 Utah Utah Man
## 36 Washington Bow Down to Washington
## 37 Washington State The Fight Song
## 38 Alabama Yea Alabama
## 39 Arkansas Arkansas Fight
## 40 Auburn War Eagle
## 41 Florida The Orange and Blue
## 42 Georgia Glory, Glory
## 43 Kentucky On! On! U of K
## 44 LSU Fight for LSU
## 45 Mississippi Forward Rebels
## 46 Mississippi State Hail State
## 47 Missouri Fight Tiger
## 48 South Carolina The Fighting Gamecocks Lead the Way (Step to the Rear)
## 49 Tennessee Rocky Top
## 50 Texas A&M Aggie War Hymn
## 51 Vanderbilt Dynamite
## 52 Boston College For Boston
## 53 Clemson Tiger Rag
## 54 Duke Fight Blue Devils
## 55 Florida State FSU Fight Song
## 56 Georgia Tech Ramblin' Wreck From Georgia Tech
## 57 Louisville Fight! U of L
## 58 Miami Miami U How-Dee-Doo
## 59 North Carolina I'm a Tar Heel Born
## 60 North Carolina State The Red & White Song
## 61 Pitt Hail to Pitt
## 62 Syracuse Down the Field
## 63 Virginia The Good Old Song
## 64 Virginia Tech Tech Triumph
## 65 Wake Forest O Here's To Wake Forest
## year writers
## 1 1908 Michael J. Shea and John F. Shea
## 2 1947 Dick Baker and Frank Boggs
## 3 1930 Jack Barker, Manly Rice, Paul Gnam, Rosalind K. Cook
## 4 1912 George "Dumpy" Bowles
## 5 1927 Harry E. Erickson
## 6 1905 Arthur M. Alden
## 7 1934 J.K. Long
## 8 1923 Walter S. Hunnicutt, James E. King and Burnett Pharr
## 9 1928 Claude Sammis
## 10 1936 Carroll McMath
## 11 1915 Earl Miller, Ed McWhorter and Fred Deem
## 12 1910 H.R. Green and H.V. Hill
## 13 1912 Russell P. Harker and Karl L. King
## 14 1950 Meredith Willson
## 15 1939 Ralph Davis
## 16 1898 Louis Elbel
## 17 1915 Francis Irving Lankey and Arthur L. Sayles
## 18 1909 Floyd Hutsell
## 19 1924 Harry Pecha
## 20 1912 Theodore C. Van Etten
## 21 1919 Frank Crumit
## 22 1933 Joseph Sanders
## 23 1912 James R. Morrison and Edward S. Wotawa
## 24 1931 Richard Hadden and W.E. Sanford
## 25 1909 William Purdy and Carl Beck
## 26 1952 Jack K. Lee
## 27 1948 Felix McKernan
## 28 1909 Earl Elleson McCoy and Robert N. Fitch
## 29 Unknown Richard Durnett
## 30 1916 DeWitt Gilbert and Albert John Perfect
## 31 1914 Harold Wilkins
## 32 1907 Aurania Ellerbeck Rouverol, Robert Browne Hall
## 33 1959 Harold P. Williams and N. Loyall McLaren; Kelly James
## 34 1922 Milo Sweet
## 35 1904 Harvey Holmes and the football team
## 36 1915 Lester J. Wilson
## 37 1919 Zella Melcher and Phyllis Sayles
## 38 1926 Ethelred Lundy (Epp) Sykes
## 39 1913 William Edwin Douglass
## 40 1955 Robert Allen and Al Stillman
## 41 1925 George Hamilton and Thornton Whitney Allen
## 42 1915 Hugh Hodgson, based on traditional song
## 43 1923 Troy Perkins and Charles A. Lampert
## 44 1937 Castro Carazo and W.G. Higginbotham
## 45 Unknown E.F. Yerby
## 46 1936 Joseph Peavey
## 47 1946 Donald MacKay and Robert Karsch
## 48 1968 Paul Dietzel and Elmer Bernstein, arranged by James Pritchard
## 49 1967 Felice and Boudleaux Bryant
## 50 1918 J.V. “Pinky” Wilson
## 51 1941 Francis Craig
## 52 Unknown T.J. Hurley
## 53 1917 Original Dixieland Jass Band
## 54 1947 Joe Hewitt and Doug Ballin
## 55 1950 Doug Alley and Tommie Wright
## 56 Unknown Unknown
## 57 1962 Robert B. Griffith
## 58 1950 Henry Fillmore
## 59 Unknown Unknown
## 60 1961 J. Perry Watson
## 61 1911 George Kirk and Lester Milton Taylor
## 62 1914 Ralph Murphy and C. Harold Lewis
## 63 1893 Edward H. Craighill
## 64 1919 Wilfred P. Maddux and Mattie Eppes
## 65 1908 C.P. Weaver
## student_writer official_song bpm sec_duration fight number_fights victory
## 1 No Yes 152 64 Yes 1 Yes
## 2 Yes Yes 76 99 Yes 4 Yes
## 3 Yes Yes 155 55 Yes 5 No
## 4 Yes Yes 137 62 No 0 No
## 5 Yes Yes 80 67 Yes 6 Yes
## 6 Yes Yes 153 37 No 0 No
## 7 No Yes 180 29 Yes 5 Yes
## 8 No Yes 81 65 Yes 17 No
## 9 No Yes 149 47 Yes 2 Yes
## 10 Yes Yes 159 54 Yes 8 Yes
## 11 Yes Yes 152 92 No 0 No
## 12 Yes Yes 162 60 No 0 Yes
## 13 Yes Yes 150 63 Yes 1 No
## 14 No Yes 150 72 Yes 9 No
## 15 Yes Yes 142 56 Yes 8 Yes
## 16 Yes Yes 83 122 No 0 No
## 17 Yes Yes 145 112 Yes 6 Yes
## 18 No Yes 151 60 No 0 No
## 19 Yes No 136 94 No 0 No
## 20 Yes Yes 140 57 Yes 1 Yes
## 21 No Yes 178 89 Yes 1 Yes
## 22 No Yes 145 81 Yes 5 Yes
## 23 Yes Yes 160 86 No 0 Yes
## 24 Yes Yes 75 74 Yes 10 Yes
## 25 No Yes 132 134 Yes 5 No
## 26 No No 144 83 No 0 No
## 27 No Yes 150 106 Yes 3 Yes
## 28 No Yes 134 88 Yes 2 Yes
## 29 Unknown Yes 151 27 Yes 8 Yes
## 30 Yes Yes 65 80 Yes 2 Yes
## 31 No Yes 137 63 Yes 2 No
## 32 Yes Yes 135 63 No 0 No
## 33 No Yes 72 69 Yes 3 No
## 34 Yes Yes 75 60 Yes 5 Yes
## 35 No Yes 168 66 Yes 1 No
## 36 No Yes 139 89 Yes 1 Yes
## 37 Yes Yes 81 64 Yes 7 Yes
## 38 Yes Yes 153 59 Yes 3 Yes
## 39 Yes Yes 77 88 Yes 3 No
## 40 No Yes 77 27 Yes 1 Yes
## 41 No Yes 71 66 Yes 1 No
## 42 Yes No 162 41 No 0 No
## 43 Yes Yes 79 52 Yes 4 Yes
## 44 No Yes 168 83 Yes 5 No
## 45 Unknown Yes 153 65 Yes 6 Yes
## 46 No Yes 146 54 Yes 2 Yes
## 47 Yes Yes 138 86 Yes 4 Yes
## 48 No Yes 153 64 Yes 4 No
## 49 No No 149 53 No 0 No
## 50 Yes No 117 172 Yes 1 No
## 51 No Yes 72 45 Yes 3 Yes
## 52 No Yes 147 84 No 0 No
## 53 No Yes 145 78 No 0 No
## 54 No Yes 139 58 Yes 5 No
## 55 Yes Yes 135 92 Yes 6 Yes
## 56 Yes Yes 148 68 No 0 No
## 57 No Yes 139 80 Yes 3 Yes
## 58 No Yes 75 73 Yes 3 Yes
## 59 Unknown Yes 158 38 No 0 No
## 60 No No 90 82 No 0 No
## 61 Yes Yes 79 110 No 0 Yes
## 62 Yes Yes 137 85 Yes 3 Yes
## 63 Yes No 112 42 No 0 No
## 64 Yes Yes 133 71 No 0 No
## 65 No Yes 146 69 No 0 No
## win_won victory_win_won rah nonsense colors men opponents spelling
## 1 Yes Yes Yes No Yes Yes No No
## 2 Yes Yes No No Yes No No Yes
## 3 No No Yes No No Yes No Yes
## 4 No No No Yes No Yes Yes No
## 5 No Yes No No Yes No No No
## 6 No No Yes No No No No Yes
## 7 No Yes No No No Yes Yes No
## 8 Yes Yes No No Yes No Yes No
## 9 No Yes Yes No Yes Yes No Yes
## 10 No Yes No No Yes No No No
## 11 No No No No No Yes No No
## 12 No Yes Yes Yes Yes Yes Yes No
## 13 No No No No Yes No No Yes
## 14 Yes Yes Yes No No No No No
## 15 Yes Yes No No No No No No
## 16 No No No No No No No No
## 17 Yes Yes Yes No Yes No No Yes
## 18 No No Yes Yes No No No Yes
## 19 No No No No No Yes No No
## 20 Yes Yes Yes No No No No No
## 21 Yes Yes No No Yes Yes No No
## 22 Yes Yes No No Yes No No Yes
## 23 No Yes No No Yes No No No
## 24 Yes Yes Yes Yes Yes Yes No Yes
## 25 Yes Yes No No No Yes No No
## 26 No No No No Yes No No No
## 27 No Yes No No Yes No No Yes
## 28 Yes Yes No No Yes Yes No No
## 29 Yes Yes No No No No No Yes
## 30 Yes Yes No No No Yes Yes No
## 31 No No No No No No No Yes
## 32 Yes Yes No No Yes Yes No No
## 33 No No No No Yes Yes Yes Yes
## 34 Yes Yes No No No Yes No Yes
## 35 No No No Yes Yes Yes No No
## 36 No Yes Yes No Yes No No No
## 37 Yes Yes No No Yes No No Yes
## 38 Yes Yes No No Yes Yes Yes No
## 39 No No Yes No No No No Yes
## 40 Yes Yes No No Yes No No No
## 41 No No No No Yes No No No
## 42 No No No No No No No Yes
## 43 Yes Yes No No Yes No No Yes
## 44 Yes Yes Yes No Yes No No Yes
## 45 Yes Yes No No Yes No No No
## 46 Yes Yes No No No No No Yes
## 47 Yes Yes No No No No No No
## 48 Yes Yes No No Yes No No Yes
## 49 No No No No No No No No
## 50 No No No Yes No Yes Yes No
## 51 Yes Yes No No No No No No
## 52 No No No No No No No No
## 53 No No No No No No No Yes
## 54 Yes Yes No No Yes No Yes No
## 55 Yes Yes No Yes No No No Yes
## 56 No No No No Yes Yes Yes No
## 57 Yes Yes Yes No No No No Yes
## 58 No Yes No No No No No Yes
## 59 No No Yes No No No No No
## 60 No No No No Yes No Yes Yes
## 61 Yes Yes No Yes Yes Yes No Yes
## 62 No Yes Yes No Yes Yes Yes No
## 63 No No Yes Yes No No No Yes
## 64 Yes Yes No Yes Yes Yes No Yes
## 65 No No Yes No Yes Yes No No
## trope_count
## 1 6
## 2 5
## 3 4
## 4 3
## 5 3
## 6 2
## 7 4
## 8 4
## 9 6
## 10 3
## 11 1
## 12 6
## 13 3
## 14 3
## 15 3
## 16 0
## 17 5
## 18 3
## 19 1
## 20 4
## 21 5
## 22 5
## 23 2
## 24 8
## 25 3
## 26 1
## 27 4
## 28 5
## 29 4
## 30 5
## 31 2
## 32 3
## 33 5
## 34 5
## 35 4
## 36 4
## 37 5
## 38 6
## 39 3
## 40 4
## 41 2
## 42 1
## 43 5
## 44 5
## 45 4
## 46 4
## 47 3
## 48 4
## 49 0
## 50 4
## 51 3
## 52 0
## 53 1
## 54 4
## 55 5
## 56 3
## 57 5
## 58 3
## 59 1
## 60 3
## 61 6
## 62 6
## 63 3
## 64 5
## 65 3The original article that analyzed this fightsong data correlated duration and beats per minute to create a matrix that ranged from songs that ranged from Fast and Short, Fast but Long, Slow but Short, Slow and Long. They also aggregate the “cliches” in each teams fight song which is pulled from the trope_count in the raw dataset. To expand on this dataset you could determine which factors such as age, student_writer and various cliches are correlated with song length and beats per minute. You could also determine if songs that were not official songs had similar characteristics. Additionally, if you could examine the popularity of fight songs through surveys of the students at each university and correlate their responses with attributes of the songs themselves.