Cocoon Cleaning Summary 🤗

---

📃 1. Table Summary

The table is about different beers. It includes details such as the beer's name, style, volume, alcohol content (ABV), and bitterness (IBU). It also provides information about the brewery that produces each beer, including the brewery's name, city, and state. Each beer has a unique ID, and each brewery has its own ID as well.

📊 2. Column Rename

😎 8 columns have been renamed

	Column	Summary	New Column Name	Renamed?
0	index	Row index in the dataset	row_number	✔️ Yes
1	id	Unique identifier for the beer	beer_id	✔️ Yes
2	beer_name	Name of the beer	beer_name	❌ No
3	style	Style or category of the beer	beer_style	✔️ Yes
4	ounces	Volume of the beer in ounces	volume_oz	✔️ Yes
5	abv	Alcohol by volume of the beer	alcohol_content	✔️ Yes
6	ibu	International Bitterness Units of the beer	bitterness	✔️ Yes
7	brewery_id	Unique identifier for the brewery	brewery_id	❌ No
8	brewery_name	Name of the brewery	brewery_name	❌ No
9	city	City where the brewery is located	brewery_city	✔️ Yes
10	state	State where the brewery is located	brewery_state	✔️ Yes

🚧 3. Erroneous Values

🔍 5 columns have erroneous values

1. beer_name: 'Czich' in 'Blonde Czich' may be a typo. '312 Urban Wheat Ale' appears twice. Some beers have year variations listed inconsistently.
   ❌ The column has not been cleaned
   
   
2. volume_oz: Inconsistent use of 'oz.', 'oz', 'ounce', 'OZ.'. Variations like 'Alumi-Tek' and 'Silo Can' add inconsistency.
   ✔️ The column has been cleaned:
   

   	Original Value	Cleaned Value
   0	12.0 oz	12.0 oz.
   1	12.0 ounce	12.0 oz.
   2	16.0 oz	16.0 oz.
   3	16.0 ounce	16.0 oz.
   4	12.0 OZ.	12.0 oz.
   5	12.0 oz. Alumi-Tek	12.0 oz.
   6	16.0 OZ.	16.0 oz.
   7	16.0 oz. Alumi-Tek	16.0 oz.
   8	12.0 oz. Silo Can	12.0 oz.
   9	24.0 ounce	24.0 oz.
   10	16.0 oz. Silo Can	16.0 oz.
   11	19.2 OZ.	19.2 oz.
   12	19.2 oz	19.2 oz.
   13	24.0 oz	24.0 oz.
   14	24.0 oz. Alumi-Tek	24.0 oz.
   15	16.9 OZ.	16.9 oz.
   16	19.2 oz. Alumi-Tek	19.2 oz.
   17	32.0 OZ.	32.0 oz.
   18	32.0 oz. Alumi-Tek	32.0 oz.
   19	8.4 ounce	8.4 oz.

   
   
3. alcohol_content: Inconsistent format: '0.05' vs '0.05%'. Redundant: '0.055999999999999994%' and '0.056'. Inconsistent precision: '0.05' vs '0.052'.
   ✔️ The column has been cleaned:
   

   	Original Value	Cleaned Value
   0	0.05%	0.050
   1	0.055%	0.055
   2	0.065%	0.065
   3	0.06%	0.060
   4	0.07%	0.070
   5	0.08%	0.080
   6	0.055999999999999994%	0.056
   7	0.057999999999999996%	0.058
   8	0.052000000000000005%	0.052
   9	0.045%	0.045
   10	0.049%	0.049
   11	0.048%	0.048
   12	0.047%	0.047
   13	0.051%	0.051
   14	0.057%	0.057
   15	0.068%	0.068
   16	0.054000000000000006%	0.054
   17	0.09	0.090%
   18	0.071	0.071%
   19	0.044	0.044%
   20	0.059000000000000004%	0.059%
   21	0.066	0.066%
   22	0.073	0.073%
   23	0.077	0.077%
   24	0.092	0.092%
   25	0.039	0.039%
   26	0.07200000000000001%	0.072%
   27	0.043	0.043%
   28	0.078	0.078%
   29	0.087	0.087%
   30	0.083	0.083%
   31	0.088	0.088%
   32	0.041	0.041%
   33	0.079	0.079%
   34	0.08199999999999999%	0.082%
   35	0.095	0.095%
   36	0.035	0.035%
   37	0.037	0.037%
   38	0.040999999999999995%	0.041%
   39	0.074	0.074%
   40	0.07400000000000001%	0.074%
   41	0.076	0.076%
   42	0.081	0.081%
   43	0.093	0.093%
   44	0.032	0.032%
   45	0.038	0.038%
   46	0.044000000000000004%	0.044%
   47	0.091%	0.091
   48	0.027000000000000003%	0.027
   49	0.035%	0.035
   50	0.077%	0.077
   51	0.078%	0.078
   52	0.079%	0.079
   53	0.083%	0.083
   54	0.085%	0.085
   55	0.087%	0.087
   56	0.092%	0.092
   57	0.096%	0.096
   58	0.09699999999999999%	0.097
   59	0.001%	0.001
   60	0.076%	0.076
   61	0.086%	0.086
   62	0.08900000000000001%	0.089
   63	0.09300000000000001%	0.093
   64	0.10400000000000001%	0.104
   65	0.125%	0.125
   66	0.128%	0.128

   
   
4. brewery_name: Some names are truncated (e.g., 'Southern Prohibition Brewing Com...'). Inconsistent use of 'Brewing Company' vs 'Brewery'.
   ✔️ The column has been cleaned:
   

   	Original Value	Cleaned Value
   0	Oskar Blues Brewery	Oskar Blues Brewing Company
   1	Sixpoint Craft Ales	Sixpoint Brewing Company
   2	Hopworks Urban Brewery	Hopworks Urban Brewing Company
   3	Stevens Point Brewery	Stevens Point Brewing Company
   4	21st Amendment Brewery	21st Amendment Brewing Company
   5	Great Crescent Brewery	Great Crescent Brewing Company
   6	Great River Brewery	Great River Brewing Company
   7	Golden Road Brewing	Golden Road Brewing Company
   8	18th Street Brewery	18th Street Brewing Company
   9	Against the Grain Brewery	Against the Grain Brewing Company
   10	Minhas Craft Brewery	Minhas Brewing Company
   11	Fort George Brewery	Fort George Brewing Company
   12	Harpoon Brewery	Harpoon Brewing Company
   13	Burn 'Em Brewing	Burn 'Em Brewing Company
   14	Capital Brewery	Capital Brewing Company
   15	Finch's Beer Company	Finch's Brewing Company
   16	Southern Prohibition Brewing Com...	Southern Prohibition Brewing Company
   17	Mikerphone Brewing	Mikerphone Brewing Company
   18	Modern Times Beer	Modern Times Beer Company
   19	Revolution Brewing	Revolution Brewing Company
   20	Rhinegeist Brewery	Rhinegeist Brewing Company
   21	TailGate Beer	TailGate Brewing Company
   22	Blackrocks Brewery	Blackrocks Brewing Company
   23	Cisco Brewers	Cisco Brewing Company
   24	Destihl Brewery	Destihl Brewing Company
   25	Eddyline Brewery & Restaurant	Eddyline Brewing Company
   26	Round Guys Brewing	Round Guys Brewing Company
   27	Atwater Brewery	Atwater Brewing Company
   28	Bell's Brewery	Bell's Brewing Company
   29	New Orleans Lager & Ale Brewing ...	New Orleans Lager & Ale Brewing Company
   30	Oskar Blues Brewery (North Carol...	Oskar Blues Brewery (North Carolina)
   31	Mehana Brewing Co.	Mehana Brewing Company
   32	Base Camp Brewing Co.	Base Camp Brewing Company
   33	Brooklyn Brewery	Brooklyn Brewing Company
   34	Cedar Creek Brewery	Cedar Creek Brewing Company
   35	Dolores River Brewery	Dolores River Brewing Company
   36	Evil Czech Brewery	Evil Czech Brewing Company
   37	Natian Brewery	Natian Brewing Company
   38	The Alchemist	The Alchemist Brewing Company
   39	Voodoo Brewery	Voodoo Brewing Company
   40	Austin Beerworks	Austin Beerworks Brewing Company
   41	Big Wood Brewery	Big Wood Brewing Company
   42	Blue Mountain Brewery	Blue Mountain Brewing Company
   43	Bohemian Brewery	Bohemian Brewing Company
   44	Evil Twin Brewing	Evil Twin Brewing Company
   45	Hilliard's Beer	Hilliard's Brewing Company
   46	Jack's Abby Craft Lagers	Jack's Abby Brewing Company
   47	Jackie O's Pub & Brewery	Jackie O's Brewing Company
   48	Morgan Street Brewery	Morgan Street Brewing Company
   49	Hawai'i Nui Brewing Co.	Hawai'i Nui Brewing Company
   50	Red Shedman Farm Brewery and Hop...	Red Shedman Farm Brewery and Hopyard
   51	Center of the Universe Brewing C...	Center of the Universe Brewing Company
   52	Swamp Head Brewery	Swamp Head Brewing Company
   53	Breckenridge Brewery	Breckenridge Brewing Company
   54	Epic Brewing	Epic Brewing Company
   55	Hops & Grain Brewery	Hops & Grain Brewing Company
   56	Chapman's Brewing	Chapman's Brewing Company
   57	Devil's Canyon Brewery	Devil's Canyon Brewing Company
   58	Liquid Hero Brewery	Liquid Hero Brewing Company
   59	Lost Nation Brewing	Lost Nation Brewing Company
   60	Mission Brewery	Mission Brewing Company
   61	Moab Brewery	Moab Brewing Company
   62	Oakshire Brewing	Oakshire Brewing Company
   63	Petoskey Brewing	Petoskey Brewing Company
   64	Saint Archer Brewery	Saint Archer Brewing Company
   65	Starr Hill Brewery	Starr Hill Brewing Company
   66	Straub Brewery	Straub Brewing Company
   67	Texian Brewing Co.	Texian Brewing Company
   68	Third Street Brewhouse	Third Street Brewing Company
   69	Three Pints Brewing	Three Pints Brewing Company
   70	Union Craft Brewing	Union Craft Brewing Company
   71	West Sixth Brewing	West Sixth Brewing Company
   72	White Birch Brewing	White Birch Brewing Company
   73	Alameda Brewing	Alameda Brewing Company
   74	Big Elm Brewing	Big Elm Brewing Company
   75	Bitter Root Brewing	Bitter Root Brewing Company
   76	Bold City Brewery	Bold City Brewing Company
   77	Carolina Beer & Beverage	Carolina Beer and Beverage
   78	Carolina Brewery	Carolina Brewing Company
   79	Flat 12 Bierwerks	Flat 12 Brewing Company
   80	French Broad Brewery	French Broad Brewing Company
   81	Grapevine Craft Brewery	Grapevine Craft Brewing Company
   82	Hardywood Park Craft Brewery	Hardywood Park Craft Brewing Company
   83	Heavy Seas Beer	Heavy Seas Brewing Company
   84	High Noon Saloon And Brewery	High Noon Saloon and Brewing Company
   85	Horny Goat Brew Pub	Horny Goat Brewing Company
   86	Intuition Ale Works	Intuition Ale Works Brewing Company
   87	Mavericks Beer Company	Mavericks Brewing Company
   88	MillKing It Productions	MillKing It Brewing Company
   89	Monkey Paw Pub & Brewery	Monkey Paw Brewing Company
   90	O'Fallon Brewery	O'Fallon Brewing Company
   91	Redhook Brewery	Redhook Brewing Company
   92	Santa Cruz Mountain Brewing	Santa Cruz Mountain Brewing Company
   93	Schilling & Company	Schilling and Company
   94	Silverton Brewery	Silverton Brewing Company
   95	Stillwater Artisanal Ales	Stillwater Artisanal Ales Brewing Company
   96	Straight to Ale	Straight to Ale Brewing Company
   97	Tapistry Brewing	Tapistry Brewing Company
   98	The Right Brain Brewery	The Right Brain Brewing Company
   99	Three Creeks Brewing	Three Creeks Brewing Company
   100	Big Lake Brewing	Big Lake Brewing Company
   101	Big Muddy Brewing	Big Muddy Brewing Company
   102	Bolero Snort Brewery	Bolero Snort Brewing Company
   103	Cape Cod Beer	Cape Cod Beer Company
   104	Catawba Island Brewing	Catawba Island Brewing Company
   105	Chatham Brewing	Chatham Brewing Company
   106	Ciderboys	Ciderboys Cider Company
   107	Jack's Hard Cider (Hauser Estate...	Jack's Hard Cider (Hauser Estate Winery)
   108	Moat Mountain Smoke House & Brew...	Moat Mountain Smoke House & Brewing Company
   109	Dad & Dude's Breweria	Dad & Dude's Brewing Company
   110	David's Ale Works	David's Ale Works Brewing Company
   111	Everybody's Brewing	Everybody's Brewing Company
   112	Fat Head's Brewery	Fat Head's Brewing Company
   113	Flying Dog Brewery	Flying Dog Brewing Company
   114	Forgotten Boardwalk	Forgotten Boardwalk Brewing Company
   115	Hale's Ales	Hale's Ales Brewing Company
   116	Half Full Brewery	Half Full Brewing Company
   117	Hangar 24 Craft Brewery	Hangar 24 Craft Brewing Company
   118	Mother's Brewing	Mother's Brewing Company
   119	Northwoods Brewpub	Northwoods Brewing Company
   120	Orpheus Brewing	Orpheus Brewing Company
   121	Mikkeller	Mikkeller Brewing Company
   122	Pine Street Brewery	Pine Street Brewing Company
   123	Pyramid Breweries	Pyramid Brewing Company
   124	River North Brewery	River North Brewing Company
   125	Seven Brides Brewery	Seven Brides Brewing Company
   126	Seattle Cider Company	Seattle Cider Brewing Company
   127	Tommyknocker Brewery	Tommyknocker Brewing Company
   128	Uncle Billy's Brewery and Smokeh...	Uncle Billy's Brewery and Smokehouse
   129	Wingman Brewers	Wingman Brewing Company
   130	Woodstock Inn, Station & Brewery	Woodstock Inn Station and Brewing Company
   131	7venth Sun	7venth Sun Brewing Company
   132	Ale Asylum	Ale Asylum Brewing Company
   133	Angry Minnow	Angry Minnow Brewing Company
   134	Arctic Craft Brewery	Arctic Craft Brewing Company
   135	Bare Hands Brewery	Bare Hands Brewing Company
   136	Black Acre Brewing Co.	Black Acre Brewing Company
   137	Breakside Brewery	Breakside Brewing Company
   138	Brew Link Brewing	Brew Link Brewing Company
   139	Burnside Brewing Co.	Burnside Brewing Company
   140	College Street Brewhouse and Pub	College Street Brewing Company
   141	Cottrell Brewing	Cottrell Brewing Company
   142	Covington Brewhouse	Covington Brewing Company
   143	Dave's Brewfarm	Dave's Brewing Company
   144	Dead Armadillo Craft Brewing	Dead Armadillo Brewing Company
   145	Deschutes Brewery	Deschutes Brewing Company
   146	Dock Street Brewery	Dock Street Brewing Company
   147	Emerald City Beer Company	Emerald City Brewing Company
   148	Engine 15 Brewing	Engine 15 Brewing Company
   149	Engine House 9	Engine House 9 Brewing Company
   150	Fullsteam Brewery	Fullsteam Brewing Company
   151	Gonzo's BiggDogg Brewing	Gonzo's BiggDogg Brewing Company
   152	Goodlife Brewing Co.	Goodlife Brewing Company
   153	Goose Island Brewery Company	Goose Island Brewing Company
   154	Gore Range Brewery	Gore Range Brewing Company
   155	Green Room Brewing	Green Room Brewing Company
   156	Grimm Brothers Brewhouse	Grimm Brothers Brewing Company
   157	Hinterland Brewery	Hinterland Brewing Company
   158	Indiana City Brewing	Indiana City Brewing Company
   159	Ipswich Ale Brewery	Ipswich Brewing Company
   160	Iron Hill Brewery & Restaurant	Iron Hill Brewing Company
   161	Krebs Brewing Company (Pete's Pl...	Krebs Brewing Company (Pete's Place)
   162	Kulshan Brewery	Kulshan Brewing Company
   163	Lazy Monk Brewing	Lazy Monk Brewing Company
   164	Mickey Finn's Brewery	Mickey Finn's Brewing Company
   165	Modern Monks Brewery	Modern Monks Brewing Company
   166	Mother Earth Brew Company	Mother Earth Brewing Company
   167	Night Shift Brewing	Night Shift Brewing Company
   168	Northampton Brewery	Northampton Brewing Company
   169	Phoenix Ale Brewery	Phoenix Ale Brewing Company
   170	Portside Brewery	Portside Brewing Company
   171	Refuge Brewery	Refuge Brewing Company
   172	Right Brain Brewery	Right Brain Brewing Company
   173	Roanoke Railhouse Brewery	Roanoke Railhouse Brewing Company
   174	Rogue Ales	Rogue Brewing Company
   175	Seabright Brewery	Seabright Brewing Company
   176	Sherwood Forest Brewers	Sherwood Forest Brewing Company
   177	Southampton Publick House	Southampton Brewing Company
   178	Speakasy Ales & Lagers	Speakeasy Brewing Company
   179	Spilker Ales	Spilker Brewing Company
   180	Stillmank Beer Company	Stillmank Brewing Company
   181	The Lion Brewery	The Lion Brewing Company
   182	The Manhattan Brewing Company	Manhattan Brewing Company
   183	The Traveler Beer Company	Traveler Brewing Company

   
   
5. brewery_city: Inconsistent state abbreviations (e.g., 'Portland OR' vs 'Boise ID'). Redundant entries like 'Chicago' and 'Chicago IL'.
   ✔️ The column has been cleaned:
   

   	Original Value	Cleaned Value
   0	Portland OR	Portland
   1	Boise ID	Boise
   2	Chicago IL	Chicago
   3	Portland ME	Portland
   4	Saint Louis MO	Saint Louis
   5	Minneapolis MN	Minneapolis
   6	San Antonio TX	San Antonio
   7	Anchorage AK	Anchorage
   8	Lincoln NE	Lincoln
   9	Louisville KY	Louisville
   10	Birmingham AL	Birmingham
   11	Gary IN	Gary
   12	Conroe TX	Conroe
   13	Export PA	Export
   14	Los Angeles CA	Los Angeles
   15	Pottstown PA	Pottstown
   16	Brooklyn Center MN	Brooklyn Center
   17	Lahaina HI	Lahaina
   18	Lyons CO	Lyons
   19	Monroe WI	Monroe
   20	Bend OR	Bend
   21	Dallas TX	Dallas
   22	Hilo HI	Hilo
   23	Houston TX	Houston
   24	Bucryus	Bucyrus
   25	Brevard	Brevard, NC
   26	Charleston	Charleston, SC
   27	Comstock Park	Comstock Park, MI
   28	Dillon	Dillon, CO
   29	Dolores	Dolores, CO
   30	Estacada	Estacada, OR
   31	Eugene	Eugene, OR
   32	Fuquay-Varina	Fuquay-Varina, NC
   33	Lake Havasu City	Lake Havasu City, AZ
   34	Lansdale	Lansdale, PA
   35	Mishawaka	Mishawaka, IN
   36	New Orleans	New Orleans, LA
   37	Reno	Reno, NV
   38	Seven Points	Seven Points, TX
   39	Sheridan	Sheridan, WY
   40	Spirit Lake	Spirit Lake, IA
   41	Waterbury	Waterbury, VT
   42	Airway Heights	Airway Heights, WA
   43	Alpine	Alpine, TX
   44	Asheville	Asheville, NC
   45	Belfast	Belfast, ME
   46	Bozeman	Bozeman, MT
   47	Bridgewater Corners	Bridgewater Corners, VT
   48	Charlottesville	Charlottesville, VA
   49	Detroit	Detroit, MI
   50	Duluth	Duluth, MN
   51	Flagstaff	Flagstaff, AZ
   52	Gainesville	Gainesville, FL
   53	Meadville	Meadville, PA
   54	Midvale	Midvale, UT
   55	Mt. Airy	Mt. Airy, MD
   56	Mustang	Mustang, OK
   57	Newport	Newport, OR
   58	Papillion	Papillion, NE
   59	Raleigh	Raleigh, NC
   60	Sacramento	Sacramento, CA
   61	Santee	Santee, CA
   62	Spring Lake	Spring Lake, MI
   63	Stratford	Stratford, CT
   64	Temecula	Temecula, CA
   65	Torrance	Torrance, CA
   66	Traverse City	Traverse City, MI
   67	Vadnais Heights	Vadnais Heights, MN
   68	Avon	Avon, CO
   69	Bellingham	Bellingham, WA
   70	Brooklyn NY	Brooklyn, NY
   71	Broomfield	Broomfield, CO
   72	Carlsbad	Carlsbad, CA
   73	Cold Spring	Cold Spring, MN
   74	Indianapolis IN	Indianapolis
   75	Boulder CO	Boulder
   76	Denver CO	Denver
   77	South Austin	Austin
   78	Longmont CO	Longmont, CO
   79	San Diego CA	San Diego, CA
   80	St Petersburg	St. Petersburg, FL
   81	St. John's	St. John's, NL
   82	Menominie	Menomonie, WI
   83	O'Fallon	O'Fallon, MO
   84	Bloomington IL	Bloomington, IL
   85	Cincinnati OH	Cincinnati, OH
   86	Fort Worth TX	Fort Worth, TX
   87	Belt	Belt, MT
   88	Biglerville	Biglerville, PA
   89	Black Mountain	Black Mountain, NC
   90	Buellton	Buellton, CA
   91	Burlington	Burlington, VT
   92	Chatham	Chatham, MA
   93	Chattanooga	Chattanooga, TN
   94	Cherry Hill	Cherry Hill, NJ
   95	Croydon	Croydon, PA
   96	Des Moines	Des Moines, IA
   97	Diamond Springs	Diamond Springs, CA
   98	Elmira	Elmira, NY
   99	Erie	Erie, PA
   100	Evanston	Evanston, IL
   101	Frankenmuth	Frankenmuth, MI
   102	Frederick	Frederick, MD
   103	Fredericksburg	Fredericksburg, VA
   104	Gadsden	Gadsden, AL
   105	Glendale	Glendale, CA
   106	Golden	Golden, CO
   107	Green Bay	Green Bay, WI
   108	Hardy	Hardy, VA
   109	Hays	Hays, KS
   110	Hayward	Hayward, CA
   111	Holland	Holland, MI
   112	Hyannis	Hyannis, MA
   113	Juneau	Juneau, AK
   114	Kalona	Kalona, IA
   115	Kinston	Kinston, NC
   116	Kirkwood	Kirkwood, MO
   117	Lake Geneva	Lake Geneva, WI
   118	Lakeside	Lakeside, CA
   119	Lancaster	Lancaster, PA
   120	Lenoir	Lenoir, NC
   121	Leominster	Leominster, MA
   122	Lewisburg	Lewisburg, PA
   123	Lockland	Lockland, OH
   124	Macon	Macon, GA
   125	Marietta	Marietta, GA
   126	Medford	Medford, OR
   127	Meridian	Meridian, ID
   128	Middleburg Heights	Middleburg Heights, OH
   129	Mooresville NC	Mooresville, NC
   130	Utica NY	Utica, NY
   131	Afton VA	Afton, VA
   132	Albuquerque NM	Albuquerque, NM
   133	Angola IN	Angola, IN
   134	Asheville NC	Asheville, NC
   135	Ashland OR	Ashland, OR
   136	Athens GA	Athens, GA
   137	Atlantic Highlands NJ	Atlantic Highlands, NJ
   138	Aurora IN	Aurora, IN
   139	Baltimore MD	Baltimore, MD
   140	Belmont CA	Belmont, CA
   141	Boston MA	Boston, MA
   142	Buellton CA	Buellton, CA
   143	Middlebury	Middlebury, VT
   144	Mill Valley	Mill Valley, CA
   145	Minnetonka	Minnetonka, MN
   146	Montauk	Montauk, NY
   147	Murphysboro	Murphysboro, IL
   148	North Conway	North Conway, NH
   149	Odessa	Odessa, TX
   150	Pacific	Pacific, MO
   151	Palisade	Palisade, CO
   152	Pinedale	Pinedale, WY
   153	Pittsburgh	Pittsburgh, PA
   154	Port Clinton	Port Clinton, OH
   155	Prescott	Prescott, AZ
   156	Redlands	Redlands, CA
   157	Ridgefield Park	Ridgefield Park, NJ
   158	Savannah	Savannah, GA
   159	Shreveport	Shreveport, LA
   160	South Deerfield	South Deerfield, MA
   161	South Lyon	South Lyon, MI
   162	St. Paul	St. Paul, MN
   163	Stamford	Stamford, CT
   164	Stevensville	Stevensville, MT
   165	Stillwater	Stillwater, MN
   166	Troutville	Troutville, VA
   167	White Salmon	White Salmon, WA
   168	Whitefish	Whitefish, MT
   169	Windsor	Windsor, CA
   170	Yakima	Yakima, WA
   171	Abingdon	Abingdon, VA
   172	Ada	Ada, MI
   173	Ann Arbor	Ann Arbor, MI
   174	Arrington	Arrington, VA
   175	Bargersville	Bargersville, IN
   176	Boynton Beach	Boynton Beach, FL
   177	Cambridge	Cambridge MA
   178	Centralia	Centralia WA
   179	Claremont	Claremont CA
   180	Colorado Springs	Colorado Springs CO
   181	Conestoga	Conestoga PA
   182	Cortland	Cortland NY
   183	Covington	Covington KY
   184	Denton	Denton TX
   185	Douglas	Douglas GA
   186	Dunedin	Dunedin FL
   187	East Windsor	East Windsor CT
   188	Everett	Everett WA
   189	Fort Wayne	Fort Wayne IN
   190	Granger	Granger IN
   191	Hudsonville	Hudsonville MI
   192	Idaho Springs	Idaho Springs CO
   193	Jacksonville Beach	Jacksonville Beach FL
   194	Kansas City	Kansas City MO
   195	Knoxville	Knoxville TN
   196	Krebs	Krebs OK
   197	Madison WI	Madison, WI
   198	Manhattan KS	Manhattan, KS
   199	Marietta GA	Marietta, GA
   200	Meadville PA	Meadville, PA
   201	Mill Valley CA	Mill Valley, CA
   202	Myrtle Beach	Myrtle Beach, SC
   203	Myrtle Beach SC	Myrtle Beach, SC
   204	Nellysford VA	Nellysford, VA
   205	North Woodstock	North Woodstock, NH
   206	North Woodstock NH	North Woodstock, NH
   207	Northamtpon	Northampton, MA
   208	Oklahoma City OK	Oklahoma City, OK
   209	Paonia CO	Paonia, CO
   210	Paso Robles CA	Paso Robles, CA
   211	Petoskey MI	Petoskey, MI
   212	Pineland ME	Pineland, ME
   213	Pittsburgh PA	Pittsburgh, PA
   214	Plainfield IN	Plainfield, IN
   215	Reno NV	Reno, NV
   216	Rochester MI	Rochester, MI
   217	San Francisco CA	San Francisco, CA
   218	San Luis Obispo CA	San Luis Obispo, CA
   219	Santa Cruz CA	Santa Cruz, CA
   220	Silverton OR	Silverton, OR
   221	Soldotna AK	Soldotna, AK
   222	South Bend	South Bend, IN
   223	South San Francisco	South San Francisco, CA
   224	Southampton	Southampton, NY
   225	Springdale AR	Springdale, AR
   226	St Paul	St. Paul, MN
   227	St. Paul MN	St. Paul, MN
   228	Stevens Point WI	Stevens Point, WI
   229	Stevensville MT	Stevensville, MT
   230	Tampa Bay	Tampa, FL
   231	Tampa Bay FL	Tampa, FL
   232	Tampa FL	Tampa, FL
   233	Tulsa	Tulsa, OK
   234	Ukiah	Ukiah, CA
   235	Virginia Beach	Virginia Beach, VA
   236	Vista	Vista, CA
   237	Waterbury VT	Waterbury, VT
   238	Waynesville	Waynesville, NC
   239	Westminster MA	Westminster, MA
   240	Wilkes-Barre	Wilkes-Barre, PA
   241	Wilmington	Wilmington, DE
   242	Wilson	Wilson, NC
   243	Wolcott	Wolcott, VT
   244	Worcester	Worcester, MA
   245	Yardley	Yardley, PA
   246	York PA	York, PA

   
   

🔧 4. Data Type

✔️ 2 columns have been casted

	Column Name	Clause	Reasoning
0	volume_oz	CAST(REGEXP_EXTRACT("volume_oz", '(\d+(\.\d+)?)') AS DECIMAL)	To transform the 'volume_oz' column from VARCHAR to DECIMAL, we need to extract the numeric part from the string and cast it to DECIMAL. The values in the column already have a consistent format where the numeric part comes first, followed by ' oz.'. We can use REGEXP_EXTRACT to get the numeric part and then cast it to DECIMAL.\n
1	alcohol_content	CASE\n WHEN regexp_full_match("alcohol_content", '0\.\d{2,3}%') THEN CAST(REGEXP_EXTRACT("alcohol_content", '(0\.\d{2,3})') AS DECIMAL)\n WHEN regexp_full_match("alcohol_content", '0\.\d{2,3}') THEN CAST("alcohol_content" AS DECIMAL)\n WHEN regexp_full_match("alcohol_content", '0\.\d') THEN CAST("alcohol_content" AS DECIMAL)\nEND	To transform the 'alcohol_content' column from VARCHAR to DECIMAL, we need to: 1. Remove the '%' sign from the end of the string. 2. Cast the remaining numeric string to DECIMAL.\nWe can achieve this using the REGEXP_EXTRACT function to extract the numeric part, and then cast it to DECIMAL. The regex pattern '0\.\d{2,3}' will match the numeric part of the alcohol content without the '%' sign.\n\nTo transform the 'alcohol_content' column from VARCHAR to DECIMAL, we can use a simple CAST function. Since the values already match the pattern '0.\d{2,3}' (a decimal number with 2 or 3 digits after the decimal point), we don't need to use REGEXP_EXTRACT. The values are already in the correct format for a decimal number, so a straightforward CAST will work.\n\nTo transform the 'alcohol_content' column from VARCHAR to DECIMAL, we can use a simple CAST function. Since the data already follows the pattern '0.\d' and contains only numeric values (e.g., '0.1'), we don't need to use REGEXP_EXTRACT. We can directly cast the column to DECIMAL.\n\n

🔗 5. Functional Dependencies

🔍 5 functional dependencies found

❓ 6. Missing Values

🔍 4 columns have missing values
✔️ 1 of them are acceptable

	Column	NULL (%)	Is NULL Acceptable?	Explanation
0	alcohol_content	2.57	False
1	beer_style	0.21	False
2	bitterness	41.70	True	Some beer styles may not have a measurable bitterness.
3	brewery_state	5.27	False