Module 11: Apply it to your data 10
Sam McShane
Import your data
data <- read.csv("../00_data/MyData.csv")Chapter 15
Create a factor
data %>% count(County)## County n
## 1 Ada 1
## 2 Addison 1
## 3 Adrian 2
## 4 Albion 2
## 5 Algoma Township 1
## 6 Algonac 1
## 7 Allegan 3
## 8 Alma 1
## 9 Alpena 1
## 10 Ann Arbor 2
## 11 Assininns 1
## 12 Atlanta 1
## 13 Augusta 1
## 14 Battle Creek 2
## 15 Bay City 3
## 16 Belding 1
## 17 Bellaire 1
## 18 Belleville 4
## 19 Berville 1
## 20 Big Rapids 3
## 21 Birmingham 1
## 22 Bloomfield 2
## 23 Borculo 1
## 24 Breckenridge 1
## 25 Bridgeport 2
## 26 Brighton 1
## 27 Brimley 1
## 28 Brooklyn 1
## 29 Brownstown 3
## 30 Burton 1
## 31 Byron 1
## 32 Calumet 1
## 33 Canton 4
## 34 Cass City 1
## 35 Central Lake 1
## 36 Charlevoix 1
## 37 Charlotte 2
## 38 Cheboygan 3
## 39 Chelsea 3
## 40 Chesaning 1
## 41 Clarksdale 1
## 42 Clarkston 2
## 43 Clinton County 2
## 44 Clinton Township 4
## 45 Clyde township 1
## 46 Cockeysville 1
## 47 Coldwater 2
## 48 Cranbrooke campus 1
## 49 Croton 1
## 50 Crystal Falls 1
## 51 Dansville 1
## 52 Davison 1
## 53 Dearborn 13
## 54 Dearborn Heights 2Modify factor order
Make two bar charts here - one before ordering another after
data %>%
group_by(County) %>%
summarise(
longitude = mean(x = longitude, na.rm = TRUE)
)## # A tibble: 54 × 2
## County longitude
## <chr> <dbl>
## 1 Ada -85.5
## 2 Addison -84.4
## 3 Adrian -84.0
## 4 Albion -84.7
## 5 Algoma Township NaN
## 6 Algonac -82.6
## 7 Allegan -85.9
## 8 Alma -84.7
## 9 Alpena -83.4
## 10 Ann Arbor -83.7
## # ℹ 44 more rowsdata## County Country
## 1 Ada United States
## 2 Addison United States
## 3 Adrian United States
## 4 Adrian United States
## 5 Albion United States
## 6 Albion United States
## 7 Algoma Township United States
## 8 Algonac United States
## 9 Allegan United States
## 10 Allegan United States
## 11 Allegan United States
## 12 Alma United States
## 13 Alpena United States
## 14 Ann Arbor United States
## 15 Ann Arbor United States
## 16 Assininns United States
## 17 Atlanta United States
## 18 Augusta United States
## 19 Battle Creek United States
## 20 Battle Creek United States
## 21 Bay City United States
## 22 Bay City United States
## 23 Bay City United States
## 24 Bellaire United States
## 25 Dearborn United States
## 26 Dearborn United States
## 27 Dearborn United States
## 28 Belding United States
## 29 Belleville United States
## 30 Belleville United States
## 31 Belleville United States
## 32 Belleville United States
## 33 Berville United States
## 34 Big Rapids United States
## 35 Big Rapids United States
## 36 Big Rapids United States
## 37 Birmingham United States
## 38 Bloomfield United States
## 39 Bloomfield United States
## 40 Borculo United States
## 41 Breckenridge United States
## 42 Bridgeport United States
## 43 Bridgeport United States
## 44 Brighton United States
## 45 Brimley United States
## 46 Brooklyn United States
## 47 Brownstown United States
## 48 Brownstown United States
## 49 Brownstown United States
## 50 Burton United States
## 51 Byron United States
## 52 Calumet United States
## 53 Canton United States
## 54 Canton United States
## 55 Canton United States
## 56 Canton United States
## 57 Cass City United States
## 58 Central Lake United States
## 59 Charlevoix United States
## 60 Charlotte United States
## 61 Charlotte United States
## 62 Cheboygan United States
## 63 Cheboygan United States
## 64 Cheboygan United States
## 65 Chelsea United States
## 66 Chelsea United States
## 67 Chelsea United States
## 68 Chesaning United States
## 69 Clarksdale United States
## 70 Clarkston United States
## 71 Clarkston United States
## 72 Clinton Township United States
## 73 Clinton Township United States
## 74 Clinton Township United States
## 75 Clinton County United States
## 76 Clinton County United States
## 77 Clinton Township United States
## 78 Clyde township United States
## 79 Cockeysville United States
## 80 Coldwater United States
## 81 Coldwater United States
## 82 Croton United States
## 83 Cranbrooke campus United States
## 84 Crystal Falls United States
## 85 Dansville United States
## 86 Davison United States
## 87 Dearborn United States
## 88 Dearborn United States
## 89 Dearborn United States
## 90 Dearborn United States
## 91 Dearborn United States
## 92 Dearborn United States
## 93 Dearborn United States
## 94 Dearborn United States
## 95 Dearborn United States
## 96 Dearborn United States
## 97 Dearborn Heights United States
## 98 Dearborn Heights United States
## description
## 1 Ada witch - Sometimes you can see a misty blue figure floating within a 3-mile radius of the Ada Cemetery on 2 Mile between Egypt Valley and Honey Creek. The story of her origin is as follows: A man suspected his wife of having an affair, so he followed her late one night when she thought he was asleep. Sure enough, she went to a field near their property where she met her lover. The husband was enraged and killed his wife, which resulted in a struggle with the other man. Both men died from their injuries. It is said that late at night (especially during the night of and the nights preceding a full moon) people driving by the field can see her ghost, searching for her lover. Some people have reported stopping to try to communicate with her, but she always disappears or runs into the woods where she cannot be followed (due to the thick brambles that inhabit the area). She is said to dress in a long white gown which authorities say dates her to the turn of the 20th century. Usually she is seen alone, but sometimes witnesses report seeing a ghostly death scene re-enacted... Others report seeing nothing at all but hearing the killer's shouts of rage followed by the victims' screams of agony... Although it is said she haunts the field on Honeycreek Road where she died, other witnesses have reported her in nearby Seidman Park, and in nearby Findlay Cemetery, where she is supposedly buried. This story was actually featured in the book "Ghosts of Grand Rapids."
## 2 A little girl was killed suddenly while waiting for a school bus by a speeding car. Since her death things have happened. The day of her funeral she started knocking on doors of the house she was born in.1 month later as her clothes were to be removed the doors in the home flew open with no reason. Cold spots now can be felt & knocking at the door is still present to this day in the home. Also when there swings in the yard you could see them swing real high as if someone was swinging on them. lights like to go on & off in this home & she does move things to let someone know she is there. The cemetery where this child lies has had alot of activity also. When you visit her grave she has a twirly that will start going around & round with no reason or wind blowing to let you know she is present. Some have said she has been spotted walking the cemetery very restless as if she doesn't realize she has passed on.
## 3 If you take Gorman Rd. west towards Sand Creek, you will come to a gravel road leading north. A mile or so up this road you will come to narrow one lane trestle bridge. The road goes under this. Legend has it that at one time there was a farm house built near the tracks. Late one night a fire broke out in the barn. While the father ran to the barn to try to get the horses out, his wife and young son went to the tracks to wave down one of the many trains that would use that right of way. They were too close to the tracks however and both were struck by the train as it went past. The father was killed in the barn. Now if you go out there late at night, you can sometimes communicate with the Father. He will not allow you to talk to his wife or son; as if he was protecting them . There are other people living in the area now, and a large streetlight has been placed there by the people who own the neighboring land. If you stay there to long, they will call the police. However if you make your visit short enough they will usually leave you to it. This place has also been described as a good place to go to contact other spirits. The Father can be asked to help in this matter. He will not allow antagonistic spirits to talk however; once again to protect his family.
## 4 In the 1970's, one room, room 211, in the old section of the dorms exhibited several phenomena. Don't know if this still continues today. The door into the room from the hallway, as well as the door into the bathroom, would open and shut on their own, the main door even if it had been locked. After closing, it would be locked again. There was also a spot on one wall (a wall that the room shared with a boarded up, no longer used laundry shaft) where two points of light would appear, shaped similar to eyes. Attempts were made to explain their appearance (they were visible any time it was dark in the room). They were screened off from the windows to see if they might be reflections, they weren't. When objects were placed between them and the windows they actually became brighter. We tried painting the walls, putting several coats of paint over them (thinking they may have been a joke of a previous resident, made with glow in the dark paint) - also having used sandpaper on the wall in that spot first before painting. They still appeared bright as ever after the painting. We tried covering them over by hanging a picture over them, but the picture kept falling down or moving. Last attempt to hang picture (it was a drawing on a piece of paper and simply taped to the wall) resulted in us waking up the next morning to find it taped to the ceiling over my bed. We finally moved a tall dresser in front of it and that seemed to take care of it. Reports from later residents told us that they had placed a mirror over it, and they had a rocker in the room. One night during a party, with several witnesses, the rocker began rocking on its own, then flew back and smashed the mirror. Have had no contact with the school since graduation, so don't know if these things still happen or not.
## 5 Kappa Delta Sorority - The Kappa Delta Sorority is haunted by an entity simply known as 'P'. It is said she was a sister there who died in a car accident. Current sisters there have reported hearing giggling and running around coming from the upstairs floor while they are in the basement. At one time a sister called out to "P" and received a "hello" in reply.
## 6 A mysterious lady in white has been spotted in this cemetery.
## 7 On a winding dirt road next to the Rogue River called Friske, there is a small turn-around for no particular reason. On this turn-around, there is a trail that leads off a ways into the woods. If you follow the trail, it leads to an old iron bridge called Hell's Bridge. It is said that if you are sitting or standing on the bridge at midnight you can hear the devil laughing. The reason is, in the 1800's, when Algoma didn't really exist and Rockford was known as Laphamville, a man named Elias Friske murdered several children and claimed a demon made him do it. Later the bodies were found in the part of the river where the bridge is now. Sometimes you can also hear the children crying, @r the noise of splashing water where their bodies were thrown. Some fishermen in the early morning have reported seeing a strange figure near the bridge...
## 8 Morrow Road is a Haunted road in Algonac Michigan near Harsens Island. In the 1800's a woman lost here child on that road and is still looking for her today. At night people see strange glowing orbs floating down the road and through the woods. Some see the lady walking by the side of the road in an 1800's dress covered in blood. Still others have reported seeing her hanging from a tree by a noose. The road has been on the popular show Unsolved Mysteries as well as several local news channels. Now there is a movie being made about the road. the story behind the road is a woman went out in the middle of the night to find her toddler that had somehow got out alone in the winter they both froze to death, it is a fact that if you park on the bridge at midnight and honk your horn three times she will appear and see if you have her baby. She is also said to be wearing a white blood covered gown carrying her dead baby. Also a green light will chase people away.- www.morrowroad.com
## 9 People report hearing footsteps, and doors slamming where there are no doors, a small child's voice say "Mama?"
## 10 Various ghostly activities. News coverage about these hauntings every year around Halloween time, on the local channels.
## 11 there have been notes of white dogs chasing cars that pull into the drive way. People have seen people hanging form trees and working in fields in old clothing. This motel is where Al Capone did some of his work and had meetings in a secret place in the tunnels. The motel was once painted blue but the next day it was back to yellow. - March 2007 update: was torn down and a tennis court was built over it.
## 12 Gamma Phi Beta House - Sisters that live in the "pink" room awoke one night to see a ghostly figure pacing back and forth between the closet door and the bedroom door. The sisters that stay in that room immediately started screaming, and the president came out of her room, opened the door and the ghost went past her. When she returned to her room everything that was hanging on the walls had fallen to the ground. Also, there are always strange things happening at the house. Things turn up missing or are moved. Strange noises can be heard throughout the night. Doors are always slamming, lights go dim, and many other strange things happen. The "hauntings" started shortly after the sisters of gamma phi beta remodeled the house...it's almost like it upset the ghost(s).
## 13 A few witnesses heard footsteps and saw heads in the windows before they were boarded up. next to the long lake chapel.
## 14 Story goes some time in the late 70s a student named Mary (last name never mentioned) who, while working on some lighting fixtures alone one day, fell from the catwalks head first and died upon the stage. Sightings include actors and stagehands seeing a girl up in the catwalks wearing a light pink dress. Also, in the prop room where all the senior thespians spray paint their names on the wall shortly after Mary's death her name appeared in bold red paint above the doorway about seventeen feet from the floor and upside down.
## 15 Mercywood was a mental hospital before closing down. security guards heard the elevators moving when the building was empty. Sounds would come from the boiler room. In the basement were personal belongings of the inmates. There was also a bowling alley and bumper pool tables in the basement. There were insane rambling written on the walls in some of the rooms. Behind the hospital there was a convent where the nuns lived that worked in the hospital and even to go in there was a very uneasy feeling. It is like you can feel the insanity that surrounded the place. Also an evil feeling. They have since torn down the old hospital but something has been built there recently. It is on Jackson Ave. in Ann Arbor a little way down from the cemetery next to I-94 on the right side if you are going west.
## 16 Before the building was turned into a Tribal Center, it used to be a Catholic Orphanage. People have sighted apparitions of little kids, nuns and priests, and have also had encounters with objects dropping or moving, and other various sounds through out the building. This entire piece of land still has a church that's active, and other inactive buildings that date back to the early 1800's.
## 17 The old cabin located on Camp 8 road is haunted by three young ghosts all sisters died during the flu epidemic in the upstairs bedroom. Reports of crying and screaming have been herd throughout the house. And pictures taken by visitors have shown more than just the three ghosts. Young children, orbs and a demon have also shown up in this film. - March 2008 Update: This is private property. No Trespassing.
## 18 Hotel now owned by Michigan State University.\xca Originally the Upjohn Family (of Upjohn Pharmaceauticals - since bought by Pharmacia and later Pfizer) summer residence.\xca Dr. Upjohn died in the Doctor's Cottage - a beautiful, upscale large cottage on the edge of the creek, surrounded by his japanese garden. Guests in staying in the cottage have told staff they hear footsteps and no one is there.\xca It's not uncommon for guests staying in the Doctor's Cottage to go to the front desk during the night to request to be moved to another room due to the strange noises and feelings of uneasiness. Hotel staff have said they hear the piano playing when alone in the Doctor's cottage, closing up after events- and yet they are the only people there. Guests staying in the carriage house have reported hearing piano music during the night - but the only piano currently on property is too far away to be heard there.
## 19 Reports of strange occurrences happened only in the East side building, usually in apartments 1-4, and 8. Closet doors would open, even when closed securely and if the closet door was closed, you can sometimes hear the coat hangers (even if immobilized in some way)tap against each other, despite the total lack of breezes or heat updrafts. Other strange happenings included: Heavy footsteps and yelling in vacant upper apartments, the feeling of an unpleasant presence, cold spots (in only one upper apartment), the feeling of being "touched" or "groped", knocking on doors, dishes being broken and pans thrown (but still intact and unmoved when you check them) and flickering lights. The buildings are about 100 years old, but no one has made any connections of deaths or tragedies to these "hauntings".
## 20 when people drive by sometimes they see a white ball run across the into a marble headstone.
## 21 Reports of apparitions and footsteps heard in there and found nobody in the building.
## 22 white objects seen entering plant, very creepy feeling, some people who have went inside have came out frightened
## 23 The legend of the Bloody Hand. For years there has been talk of the appearance of a bloody hand in the church sacristy and in the church basement as well.
## 24 The Richardi House (now known as The Grand Victorian Bed & Breakfast) is rumored to be haunted by Henri Richardi. Richardi built the house for his intended bride. When she left him for another man, he was heartbroken. Strange lights were seen in the cupola when the house was uninhabited (before being turned into a Bed & Breakfast).
## 25 The old Rouge Power House blew up in 2001 and several people died that day. If you park on Miller road late at night in front of this building you can hear vicious screams of the people thrown onto the street from the blast.
## 26 The overpass bridge also has haunting facts from the day Walter Reuther was beaten up by Harry Bennett's thugs. It is said that people who use this bridge late at night get an eerie feeling of being pushed from behind and a strange voice yells at them.
## 27 Cold spots felt. One of the most recent encounters was in one of the seventh grade classrooms. The teacher left the room to copy some papers. Right after he left, the door connecting to of the rooms together flew open. When some of the students checked, no one could've gotten into that room. They sat back down, and again, the door moved a little. Right after, the students heard faint whispering.
## 28 In the Children's section, downs stairs, sometimes you hear a small girl laughing when you are there alone. Books fall off the selves and you feel like there is someone in the room who wants you to go away even thought there is no one there.
## 29 Go down Denton Rd. at midnight and stop when you see the old road at the bottom of the hill on Denton Rd. (Unknown name of road but it's by the old cemetery) stop turn off all lights and get out of your car wait about 1-10 min. and you will see a glow float down the old road at the bottom of the hill.
## 30 Denton Rd. - There's an overall bad feeling in this cemetery. If you take a camera (preferably digital) and take pictures, you'll see orbs everywhere. There's a specific large, greenish orb that shows up in photographs quite a bit.
## 31 When the street is dark and no one is around you can put your car in park and turn you head-lights on get out of your car and stand in front of the car and you can see another car come towards you and drive right through you and your car and then disappear in seconds.
## 32 ghosts dressed in white can be seen walking through the cemetery. It always vanishes into the tallest grave there. The ghost(s) follows vehicles that drive in there at night.
## 33 An abandoned farm house located 2 miles north of Berville where a very ill 12 year old boy had died in his sleep. Drive past this house at around 1 A.M. when it is said the boy died and you may catch a glimpse of lights flickering in the windows. Inside you can hear a faint whispering, footsteps upstairs, and things will move in the house including doors being opened that were closed. enter the boys bedroom at the end of the upstairs hall and experience an overwhelming cold chill and sudden sad emotions at times.
## 34 Reports of a woman crying for help, cold chills, weird noises and intense feelings when exploring the basement, which was once opened to tunnels that ran underneath the entire town but have since been filled in.
## 35 Voices are heard often.\xca Shadows of people walking. The sound of high heels down the hallway in the back.\xca A woman in dark clothing wearing white nylons and black heels.\xca Things have been reported to fall for no reason.
## 36 The apartments are very close to Ferris State University and have many students staying there.\xca Residents have heard a young lady or small child clearly say "Hi" behind them in the apartment. When they all turned to look no one was there.
## 37 House built in 1920. Originally inhabited by Margaret parks who owned Parks Cole Company in downtown Birmingham around the same period. Countless paranormal experiences in the home. For example: lights turning on and off by themselves, curtains opening as if someone where looking out{nobody being home that is). , cold spots , ghostly apparitions both male and female, items vanishing and reappearing ( items of small size ), a strand of bells ringing in early morning hours. This is only to name a few. Also witnessed by many people. Home at a later date became the Michigan metaphysical society.
## 38 A side street north of 16 mile on Woodward holds a very creepy place called Trowbridge. It is a very rich area an local kids that were depressed would jump off the bridge which was a 100 ft. drop to there death, one instance on a Sunday from 8p.m until 12 midnight every half hour on the hour a kid would commit suicide until midnight when the train came an dismembered there corpses. The kids would spray paint there names or something to be remembered by on the wall. It is on a street called Trowbridge, very creepy street with huge houses take it down half a mile an on the left hand side before the street ends is the bridge. Go at your own risk because the place has been known to have many freaky occurrences an not to mention a monks monastery about a mile down the road. - October 2003 Update: The Police DO issue trespassing tickets for $250.00 because the train bridge and tracks are federal property and by being on it you are trespassing on federal property. - February 2004 Update: Police patrol there quite frequently and the neighbor across the street won't hesitate to call them.
## 39 Sacred Heart Academy - There is a statue of Mary with her hands raised in the air.. (You can see it as you drive by, its in the front yard.) The urban legend goes that there were 2 young boys playing by the statue. They were supposed to come home when the streetlights come on but never did. The parents started looking for them and found a bloody message on the base of this statue that said "Don't let your kids play after dark". With the fingers of the statue cut off and blood coming out. If you go there today you'll see the fingers cut off and the eyes gouged out.- August 2005 Update: This is believed to be a hoax. a visitor to our site reports the hands of the statue are intact.
## 40 What used to be an old, one-room schoolhouse, is now said to inhibit guests from the paranormal realm. It is said a former teacher, by the name of Ms. Van moss, would abuse the children so badly that one day after a playground mishap, Vanmoss struck a child so hard in the head that the child died immediately. Today, the schoolhouse is a well know restaurant, but the customers report seeing a small child sitting solemnly alone at a booth in the corner. There have also been reports of silver wear being randomly thrown across the room.
## 41 Used to be the elementary school but in 1994 they built a new one and now it is a school for mental teenagers, and a place for events. It was said A few years after the school was built(1936)there was a little space in the wall that they boarded up, and some kid unbounded it and shoved another kid in there then boarded it back up, The kid died in the hole and a while later they found him, Now if you go in there by yourself the lockers open and close by themselves and you can here kids laughing, sometimes the toilets flush by themselves and the sinks turn on and off by themselves.
## 42 there is said to be in the first years the school was built the principal was accidentally killed by a teacher....Now all the teachers that have problems with the principal face in school injuries like falling and breaking bones.
## 43 There had been said to be seen a little girl wondering the cemetery saying, "Help me\xd3. Seen by a young teenager.
## 44 before the death sentence was revoked in Michigan hundreds of inmates died in the prison. Rumors of ghost hitchhikers are known to be on the road leading to the prison. These are the souls of inmates executed while attempting escape.
## 45 Point Iroquois Lighthouse, outside of Brimley is said to be haunted, there is a story about a ghost girl who was eaten by a bear, the bear was later killed and parts of the girl where discovered inside. The site is also the location of an Indian battle, which took place in the 1600's, where the Ojibwe and Iroquois had a battle, and the Iroquois's where slaughtered. The lighthouse has had cold spots and figures have been seen.
## 46 in the house its said that there are noises that can be heard in a closet and the attic. And it is said that a man killed 3 people in the house and then himself. And so now the man is looking all over the house for the 3 people so he can kill them again.
## 47 Back in the early 90's there was a rumor heard of a man with a ax walking around in the woods and every time a kid from the neighborhood walked into the woods they would see him for a split second but then the face disappeared it was said that someone actually got it on video tape but now you only see it during a full moon you can see an extra shadow walking besides you with a man and a axe.
## 48 Rumors of a little boy and a tall man are said to haunt oak ridge anytime from about 9:00pm to 3:00 am.
## 49 there are hauntings all threw out the park. Apparitions of people walking up and down the streets late hours of the night.
## 50 ticking clocks that are not there. Things will turn on by them self.
## 51 There was a man named Nick Bradon that lived and built the house, he was plowing the field when he fell of the tractor and got ran over with the blades of the plow. There are reports of lights that go on and off, rocking chairs that rock on their own, foot steps, and there have been reports if people sleeping in the upstairs rooms have seen figure of people watching over them.
## 52 As you go in the old place back in 1903 a man was murdered but all sorts of orbs were seen and sightings and even screaming in the break of the night as you still go there you can hear screams and screams of a young girl that had died there her name was Elanda Rowe. The ghost of the great actress Helena Modjeska has also been seen here and is considered the resident ghost.
## 53 many legends about this rd. the bridge is said to be haunted by a woman who's child was killed by a car, she walks the bridge and you can hear the baby cry. dark figures chase your car and there is said to be a house on a side rd. that is haunted
## 54 The story goes that a group of kids were playing chicken near Denton Road bridge, and one of them proved to be chicken. His car swerved off the road when they reached the bridge, and crashed into the river below. Many people claim to see a light come out of river and chase their vehicle to the end of the road, if they stop at the center of the bridge at night.- November 2003 Update: the road has been reconfigured in that area and that the bridge no longer exists. That is not to say that the hauntings no longer occur.
## 55 Old Frank's Nursery & Crafts - Employees of this store were said to hear moaning after closing, along with merchandise falling off shelves. Other employees even said to be pushed by the spirit.
## 56 Reports of whispers heard and cars being pushed.
## 57 Back in the 1800's a young lady got in a horse and buggy accident. Her buggy wheel went off the bridge and flipped, she drown in 2 feet of water. On foggy summer night you can see her hand come up over the road and hear her please for help!
## 58 The Lamplights Inn has been a landmark in Central Lake since 1924. It was built in the very early 1900s. Beginning in the early '50s, the successive owners have had persistent reports of ghosts. A man and woman dressed in late '20s - early '30s garb have been seen many times over the years, not only by owners' families, but also by employees and customers alike. The descriptions are uncannily similar. A customer recently reported the man and woman ghosts dancing together in the bar area with a little girl ghost looking on. These ghosts also window peep (on the second floor). They certainly appear to be fun loving. Another story tells of the daughter of a former hotel manager, who was preparing to elope with her fianc\x8ee, and tripped on her gown while descending the ladder. She fell to her death and returns to walk the hallway upstairs in her wedding gown. And, it is a fact that Mrs. Gill who, with her husband, were the first managers of the hotel, returned and lived out her remaining years at the hotel. She died in the early '50s in one of the upstairs bedrooms. Many people have reported seeing her stand in the upstairs window looking onto the village. In 1979 Ted Strzempek bought the lamplight he said he was in the upstairs hallway painting when a women in a white dress ran by him and through all the boxes he had stacked by the wall she ran into a bedroom and he ran in after her only to find an empty room. The Murphy's now own the lamplight and if you ask them if the lamplight is haunted they will not deny it.
## 59 This spot is said to be haunted by a ghost believed to be in his late teens to early 20's who died in the grinder of the old mill that used to stand on the site.
## 60 when you are in the bottom of the theatre you will feel a coldness breeze and people say that is Rick Eaton the theatre was named after him. he died in 1923 and the theatre was built in 1902. Rick was a nice guy and his poor wife killed herself on the bottom below the upstairs and she shot herself and the bottom was where Rick died. he was up on the little balcony in the bottom and he was painting and he fell off.
## 61 people say that in the Charlotte Jr. High the old ISS room use to be a freezer room. They say back in the 60's a older man that was a teacher threw a kid in the freezer room. He got frostbitten and dies! Now the kids there say when they get in trouble and go in the ISS room the little boy haunts them.
## 62 An old farmer went insane and killed his family and then himself. If you go out to the site at night you feel overwhelmed by fright. And never take a stone from the tomb you will be dealt with in a not so nice matter. 2 people drove over the tomb on purpose and there truck just died for no reason. There friends in a car behind them had the steering wheel jerked and they crashed into a tree.
## 63 January 2007 has been removed
## 64 Years ago there was a terrible train accident and when the train tipped over there was a man who was badly hurt and the wreck jogged his mind so much that he started to beat his skull against the stump of an old tree. In the process of doing so, he asked himself "why am I hear"?. Well, he beat himself to death until his skull cracked wide open. At 1:00am in the morning you can still hear the ghost of the man saying why am I here as he beats his head on the stump.
## 65 Reports that lockers slam when no ones there and in the girls bathroom you here the toilets flush and whispers heard and behind the stage you can feel an odd presents in there when your alone.
## 66 in the dark, you can feel an odd presence of someone else there with you. There have been reports of ghost sitings near the operation rooms.
## 67 The foundation of the house is still there. They say at night the house reappears. Also at the back of the house, there are slave house's and old barn which are said to be haunted.
## 68 Store merchandise has been found moved when stores are opened in the morning. Employees hair pulled, employee shoved, voices can be heard at night. A Santa decoration was seen by 3 eye witnesses as it lifted from a table and was sat down on the floor outside a store. Transparent images of a woman and man seen separately over periods of time. Numerous unexplainable events occurring since mall opened in 1985. Unknown before this date. A smallpox outbreak in 1837 devastated some of the last remaining Indians in this area before the village of Chesaning was started.
## 69 It is said that late at night if you go over the Sunflower Bridge...turn off your car and roll down your windows that the cries of help and people yelling could be heard.
## 70 Closed Down- Sightings of people around the cinema. scratching and bumping noises heard every night. Shadows of people running on the screen. Little girl sits on the stage.
## 71 In the late 1800 a man was slaughtered off of what is now dixie and white lake road. Reports from employee's say that the man comes out at night and walks towards deer lake raquet club and back to cvs.
## 72 In the woods right off Hayes and 18 there is a small cemetery that has about 30 stones, most of them dating back to the 1800's and its said that if you come alone to the cemetery at 12:00 at night on a Friday you will very loud whispers in the woods that corner the whole cemetery and if you brave enough to stay longer the whispers come closer until there right in front of your face
## 73 There have been several acts of violence here. About 20 years ago a man escaped from a mental home and broke into the front office. In the process he broke several windows, trashed the place, slit his wrists and neck, and was found by the sales staff in the morning wrapped in a blanket talking to himself. He did not die but it was a very violent experience. 10 or so years ago a man was distressed over losing his parents and shot himself in the head overnight on top of his parent s grave. Several of the grounds crew have seen a man dematerialize in the same area a few times. This was in the summit hill garden which is the oldest garden in the cemetery. In the day or night there can be an overwhelming feeling of being watched. About 6 or 7 years ago there was a sales manager who quit after seeing an Indian in the sales office walk thru a wall. There is also a story not verified that a police officer shot a teenager on the grounds and the boy died and was buried there. In the months following the cop went mad and one night was caught wearing camouflage and face paint digging up the boy that he killed. There have also been a few graves that people have tried to dig up but have failed since the vault lids are VERY heavy. Whispers and screams have been heard.
## 74 In the Spring, Summer, and sometimes early Fall, some of the streets will have fog only at the end of them, and there will be Shadows of teenager looking people walking down the middle of the street. Also, sometimes if you cross the middle of the streets you feel a temperature drop repeatedly.
## 75 R.B.W. (Rodney B. Wilson) - People have said to hear a noise from the hall ways like a drum beating after closing hours when only the janitors are there.
## 76 Cemetery on Forest Hill Road - Witnesses claim to have taken tons of pictures of orbs here.
## 77 During The Night Here, You Can See Ghosts Of People who were killed by the train. And when you walk around the park at night you can see black figures in the wood line at the back of the park. And You Can Also See Ghosts Of Animals. Legend is that this park was built on old cemetery that was there in the 1800's.
## 78 They say that if you go to the end of Shoefelt road at about midnight on Friday nights you will here an old hunter shooting his gun off, because the old man used to hunt out there a lot and then he died and he doesn't like it when people hunt or have fun on his hunting spot so he will scare you off by shooting his gun and than walking around by your car hollering.
## 79 Built over a cemetery where odd things always seem to occur. There is a Haunted House and Haunted Hayride in October, which seems eerie because the real ghost isn't in costumes, but it is a great place to go for scares!
## 80 haunted by the ghosts 2 children who are seen on the stairs.
## 81 On the end of a deep, wide ,circular pit is a mausoleum. It is painted green, vines have long since overgrown the name and front. Pictures taken on three different days and times (lighting) all show a "mist" in the top corner. One the shape of two figures is clearly visible. Vandals have written, "meg lives" on the ground in front and a pentagram in red on the door. A deep sense of unease is felt in this circle. This is located in the old section of the cemetery, you get a very strange feeling as you walk through it.
## 82 There was a young boy in the 1970's who was fishing at the top of Croton Dam. He slipped and fell in the turbines, and was killed. Several fishermen have claimed they have seen the boy walking at the top of the dam sobbing. Most sightings have been in the early morning before sunrise. The boy's figure is illuminated by the lights at the top of the dam, and he is said to be walking about ten feet above the wall. The fisherman of the community seem to believe he is a sign of good luck, who ever spots him seems to have a prosperous day.
## 83 There is a legend that a little girl died in one of the attics in the building.Witnesses have seen a little girl standing on a fire escape looking at them. She couldn't have been a human, because it was summer and the only people there were us kids from the camp. The fire escape wasnt all the way down, so she couldn't have gotten there from the ground. Reports of feeling the need to get out fast.
## 84 In the late 1800's when iron ore mining was in its prime, a group of 27 miners were killed when the mine caved in and drowned them. People who live close by can sometimes hear screaming and noises like someone was hitting a pick against a rock. Apparitions can be seen in and around the water where the mine filled with water. Lights of the mining helmets are seen coming from below the water.
## 85 Along time ago, there was a lady who lived 2 miles back on Seven Gables Road. She was involved in witchcraft, and she put a curse on Seven Gables road. IF you heard someone scream, The last person to jump over the fence would die. a few years later, she forgot all about the curse, and she heard a baby scream, then she jumped over the fence and 2 months later she was dead. 25 years after, a man, his wife and his 2 kids, moved into that same house, The man went Mentally insane, burned down the house with his family inside, grabbed a shot gun, when down the road planning to shoot himself in the head. Instead he found a rope on a tree and hung himself. Now they say that the witch haunts seven gables, she doesn't want anyone there, Every person that has attempted to go to seven gables have taken Williamston road and either died by a car accident or almost died. No one know why. Trust me we know.
## 86 people report seeing a man run in the woods, orbs around the building ,faces looking out the window. The place is closed down now and seems not to be able to stay open. When it was open people would report dishes moving and pots and pans falling from where they are at .on the dance floor people report seeing ghost dance.December 2006 \xd0 update: About a year ago a bad wind storm collapsed the porch roof of the building, and buckled parts of the walls. The building is considered unsafe and will most likely be torn down soon.
## 87 Several years ago, when a new gym addition to the school was being built, a construction worker fell from a scaffolding and died from head injuries. Many people say that the new gym in the school is haunted and see his ghost up on the catwalk at night. If you walk down the halls of DC by yourself you always feel like something is watching you, or following you, usually due to the footstep noises. It has been said that at night, in the empty halls, if you get in the school and walk around some of the rooms are lit up and the janitor equipment will be standing outside some of the rooms, but if you go in the rooms there is no one to be found, but often strange things written on the chalk boards.
## 88 Overnight maintenance and guards have reported seeing children running through the building. The lifeguard break room is always cold and often feels like someone is watching. At night the gates rattle and shake. Children can be heard calling out "Jack" (the person the pool is named for) or the night maintenance man's name. Also footsteps can be heard throughout the night. Police often are called in to make sure it is not vandals. Never find anything but the noises continue.
## 89 Reports of many of the fire personnel that work there state that at night, a lone figure shuffles across the apparatus floor knocking over fire boots and rattling the coat hangers. Some think it is the ghost of a firefighter that refuses to retire even after death. The description is of a tall figure, glasses and mumbles about the old days gone by. The watchman of the night shift always keeps one light on for fear of this poor shade.
## 90 haunted by many ghosts in most of the homes, the most active are in Firestone Farm, and Webster home. A man committed suicide in the barn at the farm, and Webster is just unhappy.
## 91 Henry ford museum - Henry ford museum has a car from the time President Kennedy was Shot. In the evening on the anniversary he has been spotted standing next to his car waving to the security officers and leaving a single red rose on the hood of the car. Often felt a cold wind and was also told he said that there was two men that As well was not the man that shot him there was another man out side the building that was standing on the lawn where there was trees and shot him.
## 92 Doors and windows opening and shutting on their own. Several reports of the figure of a man following someone and vanishing. Reports of a man in and old fashioned uniform wandering the hallway and vanishing (a witness who spotted this later saw a picture of the Ford's butler and said that it was the same person that they spotted). The Michigan Ghost Watchers did an investigation at the estate and got pictures of orbs, mists and a figure of a man in one of Mr. Ford's cars.
## 93 It's a local community theatre to which I belong. Pictures have been taken of outlines of ghosts and it has been known to play tricks on members of The Guild. I have had a few encounters with the ghost. Hearing footsteps, when no one is around, and things moving around. At times, there is also a heavy breathing coming from stage Right.
## 94 It is known that when your in suite 418 the doors will close and open; And the lights will flicker on/off three times and the bathroom door will swing open; And the two French doors will fly open, and after you close it the handles will move up and down.
## 95 2 men died in a fire of the upstairs. When you go up there you can feel something is there with you. Employees also see figures standing in numerous places inside building.
## 96 The cleaners have claimed at nighttime to have felt presences and witnessed the lockers opening and shutting. You always feel as if your not alone. It is believed to be the spirits of golf legends.
## 97 About 33 years ago, at a old school called Berwyn elementary(located at Berwyn and Richardson), there was a janitor that hung himself in the location of where the library stands today. Today it is called the Berwyn Senior Center. It is said by the senior citizens, and neighborhood kids, that they hear keys rattling, tapping on the glass of the library windows, moaning, and sometimes a figure or a face in the library's windows. Many say that this place is haunted.
## 98 Computer number 25 is definitely haunted by an old senior who didn't not graduate because he failed computers. Now the computer acts up and any senior who sits at that computer passes with an 'A'. All the work is already done. This ghost is unlike any other ghost, he is a kind one!
## location state
## 1 Ada Cemetery Michigan
## 2 North Adams Rd. Michigan
## 3 Ghost Trestle Michigan
## 4 Siena Heights University Michigan
## 5 Albion College Michigan
## 6 Riverside Cemetery Michigan
## 7 Hell's Bridge Michigan
## 8 Morrow Road Michigan
## 9 Elks Lodge Michigan
## 10 The Grill House and the Rock Bottom Bar Michigan
## 11 The Yellow Motel Michigan
## 12 Alma College Michigan
## 13 old radio tavern Michigan
## 14 Huron High School theatre. Michigan
## 15 Mercywood Hospital Michigan
## 16 the old tribal center/orphanage Michigan
## 17 Camp 8 Cabin Michigan
## 18 Brook Lodge Hotel Michigan
## 19 Court Apartments (formally Webster Apartments) Michigan
## 20 Penfield cemetery Michigan
## 21 Delta College Michigan
## 22 old water treatment plant Michigan
## 23 Our Lady of the Visitation Church Michigan
## 24 Richardi House Michigan
## 25 Ford Rouge Plant Michigan
## 26 Ford Rouge Plant \xd0 Overpass Bridge Michigan
## 27 O.L. Smith Middle School Michigan
## 28 Belding Library Michigan
## 29 94 & Denton Rd. Michigan
## 30 Cemetery off S. Service Drive Michigan
## 31 Robson Rd Michigan
## 32 Tyler Rd. Cemetery Michigan
## 33 Berville Rd. Michigan
## 34 Big Rapids Cinema Michigan
## 35 Ponderosa Michigan
## 36 Rapids Apartments Michigan
## 37 Adams house Michigan
## 38 Trowbridge Road Michigan
## 39 Trowbridge Road Michigan
## 40 The Old School House Michigan
## 41 AIM School Michigan
## 42 Bridgeport High School Michigan
## 43 Cole Rd. Cemetery Michigan
## 44 Brighton Women's correctional institute Michigan
## 45 Point Iroquois Lighthouse Michigan
## 46 Clarklake Michigan
## 47 Dawnshire Park Michigan
## 48 Oak ridge cemetery on Telegraph Michigan
## 49 Tela Valley Michigan
## 50 Naturally You Michigan
## 51 McGuire's House Michigan
## 52 Calumet theatre Michigan
## 53 Denton rd Michigan
## 54 Denton Road Bridge Michigan
## 55 Ford Road Michigan
## 56 Gyde Rd. Michigan
## 57 Crawford Rd. bridge Michigan
## 58 Murphy's Lamplight Inn Michigan
## 59 Weathervane Restaurant Michigan
## 60 Eaton Theatre Michigan
## 61 Old Charlotte Jr. High Michigan
## 62 Hikyes Tomb Michigan
## 63 Pellston Michigan
## 64 Where the old Train Station used to be Michigan
## 65 Beach Middle School Michigan
## 66 Chelsea hospital Michigan
## 67 Pink Palace Michigan
## 68 Chesaning Market Street Square (a mini mall with indoor shops) Michigan
## 69 Sunflower Bridge Michigan
## 70 Clarkston Cinema Michigan
## 71 CVS off dixie us 20 Michigan
## 72 18 mile road and Hayes Michigan
## 73 Cadillac Memorial Gardens East Michigan
## 74 Chateau Clinton Trailer Park Michigan
## 75 St. Johns Michigan
## 76 St. Johns/Clinton County Michigan
## 77 Rudgate Manufactured Home Park Michigan
## 78 Shoefelt Rd Michigan
## 79 Padonia Park Club Michigan
## 80 Halstead House Michigan
## 81 Oak Hill Cemetery Michigan
## 82 Croton Dam Michigan
## 83 the elementary school Michigan
## 84 Mansfield mine cave-in Michigan
## 85 Seven Gables Michigan
## 86 Russelville ballroom Michigan
## 87 Divine Child High School Michigan
## 88 Dunworth Pool (Seashore) Michigan
## 89 Fire Station 2 Michigan
## 90 Greenfield Village Michigan
## 91 Greenfiled village Michigan
## 92 The Henry Ford Estate Michigan
## 93 Players Guild of Dearborn Michigan
## 94 Ritz Carlton Hotel Michigan
## 95 Showcase cinema Michigan
## 96 Tournament Players Club Michigan
## 97 Berwyn Senior Center Michigan
## 98 Crestwood Computer Lab Michigan
## state_abbrev longitude latitude city_longitude city_latitude
## 1 MI -85.50489 42.96211 -85.49548 42.96073
## 2 MI -84.38184 41.97142 -84.34717 41.98643
## 3 MI -84.03566 41.90454 -84.03717 41.89755
## 4 MI -84.01757 41.90571 -84.03717 41.89755
## 5 MI -84.74518 42.24401 -84.75303 42.24310
## 6 MI -84.75306 42.23681 -84.75303 42.24310
## 7 MI NA NA -85.62293 43.14929
## 8 MI -82.57629 42.65300 -82.53102 42.61837
## 9 MI -85.84160 42.52055 -85.85530 42.52920
## 10 MI -85.85756 42.49776 -85.85530 42.52920
## 11 MI -85.87442 42.53416 -85.85530 42.52920
## 12 MI -84.66994 43.37901 -84.65973 43.37892
## 13 MI -83.43371 45.06291 -83.43275 45.06168
## 14 MI -83.70264 42.28139 -83.74304 42.28083
## 15 MI -83.65416 42.26488 -83.74304 42.28083
## 16 MI NA NA -88.47735 46.81021
## 17 MI -84.28782 44.84783 -84.14389 45.00473
## 18 MI NA NA -85.35222 42.33643
## 19 MI -85.17807 42.29793 -85.17971 42.32115
## 20 MI -85.17774 42.30621 -85.17971 42.32115
## 21 MI -83.98600 43.55795 -83.88886 43.59447
## 22 MI -83.87410 43.62581 -83.88886 43.59447
## 23 MI -83.89454 43.61662 -83.88886 43.59447
## 24 MI -85.20995 44.98044 -85.21117 44.98028
## 25 MI -83.23311 42.30311 -83.17631 42.32226
## 26 MI -83.23311 42.30311 -83.17631 42.32226
## 27 MI -83.26831 42.28790 -83.17631 42.32226
## 28 MI -85.22682 43.09785 -85.22891 43.09781
## 29 MI -94.81971 45.66821 -83.48521 42.20476
## 30 MI -83.52281 42.21671 -83.48521 42.20476
## 31 MI -83.47571 42.24143 -83.48521 42.20476
## 32 MI -83.42984 42.23738 -83.48521 42.20476
## 33 MI -82.88574 42.92324 -82.88298 42.90836
## 34 MI -85.48151 43.69647 -85.48366 43.69808
## 35 MI -85.39606 44.24520 -85.48366 43.69808
## 36 MI -85.48561 43.69018 -85.48366 43.69808
## 37 MI -83.20579 42.54177 -83.21132 42.54670
## 38 MI -83.23422 42.57783 -83.28271 42.57931
## 39 MI -83.23422 42.57783 -83.28271 42.57931
## 40 MI -86.01377 42.88500 -86.02115 42.88502
## 41 MI -84.47592 43.41465 -84.47500 43.40808
## 42 MI -83.86981 43.35531 -83.88164 43.35947
## 43 MI -83.06382 42.51665 -83.88164 43.35947
## 44 MI -83.69543 42.51912 -83.78022 42.52948
## 45 MI -84.63217 46.48425 -84.69201 46.37405
## 46 MI -84.24828 42.10587 -84.24828 42.10587
## 47 MI -83.22100 42.16633 -83.25723 42.12612
## 48 MI -83.26951 42.13149 -83.25723 42.12612
## 49 MI -83.26191 42.17717 -83.25723 42.12612
## 50 MI NA NA -83.61634 42.99947
## 51 MI NA NA -83.94440 42.82281
## 52 MI -88.45344 47.24782 -88.45401 47.24659
## 53 MI -83.52523 42.28532 -83.48212 42.30864
## 54 MI -83.52523 42.28532 -83.48212 42.30864
## 55 MI -83.48953 42.32187 -83.48212 42.30864
## 56 MI -83.51773 42.34290 -83.48212 42.30864
## 57 MI -83.13342 43.57280 -83.17467 43.60085
## 58 MI -85.26492 45.07209 -85.26451 45.07000
## 59 MI -85.25928 45.31925 -85.25840 45.31806
## 60 MI -84.83549 42.56126 -84.83582 42.56365
## 61 MI -84.85649 42.55570 -84.83582 42.56365
## 62 MI NA NA -84.47448 45.64696
## 63 MI -84.78394 45.55279 -84.47448 45.64696
## 64 MI NA NA -84.47448 45.64696
## 65 MI -84.00964 42.31824 -84.02050 42.31809
## 66 MI -84.01651 42.31042 -84.02050 42.31809
## 67 MI NA NA -84.02050 42.31809
## 68 MI NA NA -84.11497 43.18475
## 69 MI -83.34261 42.71506 -83.41929 42.73512
## 70 MI -83.43415 42.66051 -83.41929 42.73512
## 71 MI -83.42616 42.72296 -83.41929 42.73512
## 72 MI -82.97203 42.59754 -82.91955 42.58689
## 73 MI -82.95641 42.58116 -82.91955 42.58689
## 74 MI -82.97079 42.57647 -82.91955 42.58689
## 75 MI -84.55915 43.00114 -84.52222 42.96635
## 76 MI -84.55915 43.00114 -84.52222 42.96635
## 77 MI -82.91593 42.57926 -82.91955 42.58689
## 78 MI -82.56376 43.03627 -82.58349 43.03132
## 79 MI -76.67117 39.45364 NA NA
## 80 MI NA NA -85.00052 41.94033
## 81 MI -85.17774 42.30621 -85.00052 41.94033
## 82 MI -85.66339 43.43711 -85.62293 43.41943
## 83 MI -83.24118 42.57700 -83.24118 42.57700
## 84 MI NA NA -88.33402 46.09801
## 85 MI -84.31727 42.52933 -84.30330 42.55587
## 86 MI -83.51640 43.03136 -83.51801 43.03475
## 87 MI -83.28308 42.31867 -83.17631 42.32226
## 88 MI -83.27809 42.31715 -83.17631 42.32226
## 89 MI -83.26398 42.30535 -83.17631 42.32226
## 90 MI -83.22465 42.30532 -83.17631 42.32226
## 91 MI -83.22465 42.30532 -83.17631 42.32226
## 92 MI -83.23241 42.31403 -83.17631 42.32226
## 93 MI -83.24965 42.29128 -83.17631 42.32226
## 94 MI -83.21709 42.32046 -83.17631 42.32226
## 95 MI -83.27263 42.29821 -83.17631 42.32226
## 96 MI -83.20085 42.30644 -83.17631 42.32226
## 97 MI -83.29727 42.33677 -83.27326 42.33698
## 98 MI -83.29324 42.32209 -83.27326 42.33698# Plot
data %>%
ggplot(aes(x = longitude, y = County)) +
geom_point()## Warning: Removed 11 rows containing missing values or values outside the scale range
## (`geom_point()`).
Modify factor levels
Show examples of three functions:
data %>% distinct(County)## County
## 1 Ada
## 2 Addison
## 3 Adrian
## 4 Albion
## 5 Algoma Township
## 6 Algonac
## 7 Allegan
## 8 Alma
## 9 Alpena
## 10 Ann Arbor
## 11 Assininns
## 12 Atlanta
## 13 Augusta
## 14 Battle Creek
## 15 Bay City
## 16 Bellaire
## 17 Dearborn
## 18 Belding
## 19 Belleville
## 20 Berville
## 21 Big Rapids
## 22 Birmingham
## 23 Bloomfield
## 24 Borculo
## 25 Breckenridge
## 26 Bridgeport
## 27 Brighton
## 28 Brimley
## 29 Brooklyn
## 30 Brownstown
## 31 Burton
## 32 Byron
## 33 Calumet
## 34 Canton
## 35 Cass City
## 36 Central Lake
## 37 Charlevoix
## 38 Charlotte
## 39 Cheboygan
## 40 Chelsea
## 41 Chesaning
## 42 Clarksdale
## 43 Clarkston
## 44 Clinton Township
## 45 Clinton County
## 46 Clyde township
## 47 Cockeysville
## 48 Coldwater
## 49 Croton
## 50 Cranbrooke campus
## 51 Crystal Falls
## 52 Dansville
## 53 Davison
## 54 Dearborn Heights# Recode
data %>%
# Rename levels
mutate(race_rev =fct_recode(County, "Addison" = "Addison")) %>%
select(County, longitude) %>%
filter(longitude == "long")## [1] County longitude
## <0 rows> (or 0-length row.names)data %>%
mutate(race_col = fct_collapse(County, "County" =c("Within", "Other"))) %>%
select(County, race_col) %>%
filter(County != "Byron")## Warning: There was 1 warning in `mutate()`.
## ℹ In argument: `race_col = fct_collapse(County, County = c("Within",
## "Other"))`.
## Caused by warning:
## ! Unknown levels in `f`: Within, Other## County race_col
## 1 Ada Ada
## 2 Addison Addison
## 3 Adrian Adrian
## 4 Adrian Adrian
## 5 Albion Albion
## 6 Albion Albion
## 7 Algoma Township Algoma Township
## 8 Algonac Algonac
## 9 Allegan Allegan
## 10 Allegan Allegan
## 11 Allegan Allegan
## 12 Alma Alma
## 13 Alpena Alpena
## 14 Ann Arbor Ann Arbor
## 15 Ann Arbor Ann Arbor
## 16 Assininns Assininns
## 17 Atlanta Atlanta
## 18 Augusta Augusta
## 19 Battle Creek Battle Creek
## 20 Battle Creek Battle Creek
## 21 Bay City Bay City
## 22 Bay City Bay City
## 23 Bay City Bay City
## 24 Bellaire Bellaire
## 25 Dearborn Dearborn
## 26 Dearborn Dearborn
## 27 Dearborn Dearborn
## 28 Belding Belding
## 29 Belleville Belleville
## 30 Belleville Belleville
## 31 Belleville Belleville
## 32 Belleville Belleville
## 33 Berville Berville
## 34 Big Rapids Big Rapids
## 35 Big Rapids Big Rapids
## 36 Big Rapids Big Rapids
## 37 Birmingham Birmingham
## 38 Bloomfield Bloomfield
## 39 Bloomfield Bloomfield
## 40 Borculo Borculo
## 41 Breckenridge Breckenridge
## 42 Bridgeport Bridgeport
## 43 Bridgeport Bridgeport
## 44 Brighton Brighton
## 45 Brimley Brimley
## 46 Brooklyn Brooklyn
## 47 Brownstown Brownstown
## 48 Brownstown Brownstown
## 49 Brownstown Brownstown
## 50 Burton Burton
## 51 Calumet Calumet
## 52 Canton Canton
## 53 Canton Canton
## 54 Canton Canton
## 55 Canton Canton
## 56 Cass City Cass City
## 57 Central Lake Central Lake
## 58 Charlevoix Charlevoix
## 59 Charlotte Charlotte
## 60 Charlotte Charlotte
## 61 Cheboygan Cheboygan
## 62 Cheboygan Cheboygan
## 63 Cheboygan Cheboygan
## 64 Chelsea Chelsea
## 65 Chelsea Chelsea
## 66 Chelsea Chelsea
## 67 Chesaning Chesaning
## 68 Clarksdale Clarksdale
## 69 Clarkston Clarkston
## 70 Clarkston Clarkston
## 71 Clinton Township Clinton Township
## 72 Clinton Township Clinton Township
## 73 Clinton Township Clinton Township
## 74 Clinton County Clinton County
## 75 Clinton County Clinton County
## 76 Clinton Township Clinton Township
## 77 Clyde township Clyde township
## 78 Cockeysville Cockeysville
## 79 Coldwater Coldwater
## 80 Coldwater Coldwater
## 81 Croton Croton
## 82 Cranbrooke campus Cranbrooke campus
## 83 Crystal Falls Crystal Falls
## 84 Dansville Dansville
## 85 Davison Davison
## 86 Dearborn Dearborn
## 87 Dearborn Dearborn
## 88 Dearborn Dearborn
## 89 Dearborn Dearborn
## 90 Dearborn Dearborn
## 91 Dearborn Dearborn
## 92 Dearborn Dearborn
## 93 Dearborn Dearborn
## 94 Dearborn Dearborn
## 95 Dearborn Dearborn
## 96 Dearborn Heights Dearborn Heights
## 97 Dearborn Heights Dearborn Heightsdata %>% count(County)## County n
## 1 Ada 1
## 2 Addison 1
## 3 Adrian 2
## 4 Albion 2
## 5 Algoma Township 1
## 6 Algonac 1
## 7 Allegan 3
## 8 Alma 1
## 9 Alpena 1
## 10 Ann Arbor 2
## 11 Assininns 1
## 12 Atlanta 1
## 13 Augusta 1
## 14 Battle Creek 2
## 15 Bay City 3
## 16 Belding 1
## 17 Bellaire 1
## 18 Belleville 4
## 19 Berville 1
## 20 Big Rapids 3
## 21 Birmingham 1
## 22 Bloomfield 2
## 23 Borculo 1
## 24 Breckenridge 1
## 25 Bridgeport 2
## 26 Brighton 1
## 27 Brimley 1
## 28 Brooklyn 1
## 29 Brownstown 3
## 30 Burton 1
## 31 Byron 1
## 32 Calumet 1
## 33 Canton 4
## 34 Cass City 1
## 35 Central Lake 1
## 36 Charlevoix 1
## 37 Charlotte 2
## 38 Cheboygan 3
## 39 Chelsea 3
## 40 Chesaning 1
## 41 Clarksdale 1
## 42 Clarkston 2
## 43 Clinton County 2
## 44 Clinton Township 4
## 45 Clyde township 1
## 46 Cockeysville 1
## 47 Coldwater 2
## 48 Cranbrooke campus 1
## 49 Croton 1
## 50 Crystal Falls 1
## 51 Dansville 1
## 52 Davison 1
## 53 Dearborn 13
## 54 Dearborn Heights 2data %>% mutate(race_lump = fct_lump(County)) %>% distinct(race_lump)## race_lump
## 1 Ada
## 2 Addison
## 3 Adrian
## 4 Albion
## 5 Algoma Township
## 6 Algonac
## 7 Allegan
## 8 Alma
## 9 Alpena
## 10 Ann Arbor
## 11 Assininns
## 12 Atlanta
## 13 Augusta
## 14 Battle Creek
## 15 Bay City
## 16 Bellaire
## 17 Dearborn
## 18 Belding
## 19 Belleville
## 20 Berville
## 21 Big Rapids
## 22 Birmingham
## 23 Bloomfield
## 24 Borculo
## 25 Breckenridge
## 26 Bridgeport
## 27 Brighton
## 28 Brimley
## 29 Brooklyn
## 30 Brownstown
## 31 Burton
## 32 Byron
## 33 Calumet
## 34 Canton
## 35 Cass City
## 36 Central Lake
## 37 Charlevoix
## 38 Charlotte
## 39 Cheboygan
## 40 Chelsea
## 41 Chesaning
## 42 Clarksdale
## 43 Clarkston
## 44 Clinton Township
## 45 Clinton County
## 46 Clyde township
## 47 Cockeysville
## 48 Coldwater
## 49 Croton
## 50 Cranbrooke campus
## 51 Crystal Falls
## 52 Dansville
## 53 Davison
## 54 Dearborn Heights- fct_collapse
- fct_lump