티스토리 뷰
In [1]:
import pandas as pd
df=pd.read_csv('finally_beer_1.csv')
df
Out[1]:
| user | beer_name | brewery | beer_style | score | date | 월 | 일 | 년 | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | Worthington's White Shield | Molson Coors UK (Molson Coors) | Premium Bitter/ESB | 4.4 | 2000-04-16 | 4 | 16 | 2000 |
| 1 | 2 | Rogue Dry Hopped St. Rogue Red Ale | Rogue Ales | Amber Ale | 4.3 | 2000-04-23 | 4 | 23 | 2000 |
| 2 | 2 | Maclay Oat Malt Stout | Clockwork (Maclay) | Stout | 2.4 | 2000-04-28 | 4 | 28 | 2000 |
| 3 | 2 | Newcastle Brown Ale | Heineken Nederland | Brown Ale | 3.9 | 2000-04-28 | 4 | 28 | 2000 |
| 4 | 2 | Rogue Mocha Porter | Rogue Ales | Porter | 4.9 | 2000-04-28 | 4 | 28 | 2000 |
| 5 | 2 | Flying Dog Doggie Style Pale Ale | Flying Dog Brewery | American Pale Ale | 4.4 | 2000-04-28 | 4 | 28 | 2000 |
| 6 | 2 | Fuller's India Pale Ale (Bottle/Keg) | Fuller's | India Pale Ale (IPA) | 3.5 | 2000-04-28 | 4 | 28 | 2000 |
| 7 | 2 | Samuel Adams Pale Ale | Boston Beer Company | English Pale Ale | 3.6 | 2000-05-03 | 5 | 3 | 2000 |
| 8 | 2 | Dogwood Breakdown IPA | Dogwood Brewing Company (GA) | India Pale Ale (IPA) | 4.3 | 2000-05-03 | 5 | 3 | 2000 |
| 9 | 2 | King and Barnes IPA | King and Barnes | Premium Bitter/ESB | 4.3 | 2000-05-03 | 5 | 3 | 2000 |
| 10 | 2 | Sweetwater IPA | Sweetwater Brewing Company | India Pale Ale (IPA) | 4.3 | 2000-05-03 | 5 | 3 | 2000 |
| 11 | 2 | Samuel Smiths India Ale | Samuel Smith | Premium Bitter/ESB | 3.5 | 2000-05-03 | 5 | 3 | 2000 |
| 12 | 2 | Samuel Smiths Organic / Old Brewery Pale Ale | Samuel Smith | Premium Bitter/ESB | 4.5 | 2000-05-03 | 5 | 3 | 2000 |
| 13 | 2 | Dogwood Pale Ale | Dogwood Brewing Company (GA) | English Pale Ale | 3.5 | 2000-05-03 | 5 | 3 | 2000 |
| 14 | 2 | Boddingtons Pub Ale (Can) | Samlesbury (AB InBev UK) | Bitter | 2.8 | 2000-05-03 | 5 | 3 | 2000 |
| 15 | 2 | Ruddles County (Filtered) | Greene King | Premium Bitter/ESB | 3.6 | 2000-05-03 | 5 | 3 | 2000 |
| 16 | 2 | Redhook ESB | Redhook Brewery | Premium Bitter/ESB | 1.9 | 2000-05-03 | 5 | 3 | 2000 |
| 17 | 2 | North Coast Red Seal Ale | North Coast Brewing Company | American Pale Ale | 4.2 | 2000-05-03 | 5 | 3 | 2000 |
| 18 | 2 | Grolsch Amber Ale | Grolsche Bierbrouwerij Ned. (Asahi) | Amber Ale | 3.5 | 2000-05-03 | 5 | 3 | 2000 |
| 19 | 2 | Rogue Nation Brutal India Pale Ale | Rogue Ales | India Pale Ale (IPA) | 4.7 | 2000-05-03 | 5 | 3 | 2000 |
| 20 | 2 | Rogue HazelNut Brown Nectar | Rogue Ales | Brown Ale | 4.4 | 2000-05-03 | 5 | 3 | 2000 |
| 21 | 2 | Flying Dog Snake Dog IPA (through 2007) | Flying Dog Brewery | India Pale Ale (IPA) | 2.9 | 2000-05-04 | 5 | 4 | 2000 |
| 22 | 2 | Guinness Draught | St. James's Gate (Diageo) | Dry Stout | 4.7 | 2000-05-10 | 5 | 10 | 2000 |
| 23 | 2 | Samuel Adams Boston Ale | Boston Beer Company | Amber Ale | 3.6 | 2000-05-19 | 5 | 19 | 2000 |
| 24 | 2 | Heineken | Heineken Nederland | Pale Lager | 1.9 | 2000-05-23 | 5 | 23 | 2000 |
| 25 | 2 | Harpoon Pilsner | Harpoon Brewery | Pilsener | 2.8 | 2000-05-23 | 5 | 23 | 2000 |
| 26 | 2 | Harpoon Dark | Harpoon Brewery | Dunkel/Tmavý | 4.0 | 2000-05-25 | 5 | 25 | 2000 |
| 27 | 2 | Harpoon Ale | Harpoon Brewery | Amber Ale | 4.2 | 2000-05-25 | 5 | 25 | 2000 |
| 28 | 2 | Paulaner Hefe-Weissbier (Hefe-Weizen) (5.5%) | Paulaner Brauerei (Schörghuber) | German Hefeweizen | 4.7 | 2000-05-28 | 5 | 28 | 2000 |
| 29 | 2 | Tuppers Hop Pocket Ale | Tuppers' Hop Pocket Beers | American Pale Ale | 3.1 | 2000-05-28 | 5 | 28 | 2000 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8281216 | 570319 | Lawson's Finest Sip of Sunshine IPA | Lawson's Finest Liquids | Imperial IPA | 5.0 | 2018-07-08 | 7 | 8 | 2018 |
| 8281217 | 570319 | 7 Devils Double Hop IPA | 7 Devils Brewing Company | India Pale Ale (IPA) | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281218 | 570319 | Four Peaks Peach Ale | Four Peaks Brewing Company (AB InBev) | Fruit Beer | 3.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281219 | 570319 | Scottsdale Beer Co. Easy Amber | Scottsdale Beer Company | Amber Ale | 3.4 | 2018-07-14 | 7 | 14 | 2018 |
| 8281220 | 570319 | Scottsdale Beer Co. Big O Irish Red | Scottsdale Beer Company | Irish Ale | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281221 | 570319 | Scottsdale Beer Co. Galactic IPA | Scottsdale Beer Company | India Pale Ale (IPA) | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281222 | 570319 | 54°40' Or Fight | 54°40' Brewing Company | Black IPA | 3.2 | 2018-07-14 | 7 | 14 | 2018 |
| 8281223 | 570319 | 54°40' Käscadia Kölsch | 54°40' Brewing Company | Kölsch | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281224 | 570319 | Rentsch IPA | Rentsch Brewery | India Pale Ale (IPA) | 3.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281225 | 570319 | Kona Longboard Island Lager | Kona Brewing Company | Pale Lager | 3.5 | 2018-07-14 | 7 | 14 | 2018 |
| 8281226 | 570319 | Too Sticky To Roll (NW IRA) | Burnside Brewing Company (OR) | India Pale Ale (IPA) | 4.5 | 2018-07-14 | 7 | 14 | 2018 |
| 8281227 | 570319 | Burnside Sweet Heat | Burnside Brewing Company (OR) | Spice/Herb/Vegetable | 3.9 | 2018-07-14 | 7 | 14 | 2018 |
| 8281228 | 570319 | Rogue Farms 10 Hop IPA | Rogue Ales | Imperial IPA | 4.4 | 2018-07-14 | 7 | 14 | 2018 |
| 8281229 | 570319 | Rogue Dead Guy Ale | Rogue Ales | Heller Bock | 4.2 | 2018-07-14 | 7 | 14 | 2018 |
| 8281230 | 570319 | Lagunitas Undercover Investigation Shut-Down Ale | Lagunitas Brewing Company (Heineken) | American Strong Ale | 4.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281231 | 570319 | Lagunitas A Little Sumpin' Sumpin' Ale | Lagunitas Brewing Company (Heineken) | India Pale Ale (IPA) | 4.1 | 2018-07-14 | 7 | 14 | 2018 |
| 8281232 | 570319 | Everybody's Tiny Tank Series: On That Dust IPA | Everybody's Brewing | India Pale Ale (IPA) | 4.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281233 | 570319 | Everybody's Local Logger Lager | Everybody's Brewing | Premium Lager | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281234 | 570319 | No-Li Komrade | No-Li Brewhouse | Imperial IPA | 4.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281235 | 570319 | Lagunitas Lucky 13 | Lagunitas Brewing Company (Heineken) | American Strong Ale | 4.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281236 | 570319 | Loowit Super Ninja | Loowit Brewing Company | Imperial IPA | 4.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281237 | 570319 | Loowit Two-Sixteen Red Ale | Loowit Brewing Company | Amber Ale | 4.5 | 2018-07-14 | 7 | 14 | 2018 |
| 8281238 | 570319 | Loowit Shadow Shinobi IPA | Loowit Brewing Company | India Pale Ale (IPA) | 4.4 | 2018-07-14 | 7 | 14 | 2018 |
| 8281239 | 570319 | Victor 23 Terminal Velocity | Victor 23 Brewing | Specialty Grain | 3.4 | 2018-07-15 | 7 | 15 | 2018 |
| 8281240 | 570319 | Victor 23 Jet Fuel Imperial IPA | Victor 23 Brewing | Imperial IPA | 3.9 | 2018-07-15 | 7 | 15 | 2018 |
| 8281241 | 570319 | Railside Trestle NW IPA | Railside Brewing | India Pale Ale (IPA) | 3.7 | 2018-07-15 | 7 | 15 | 2018 |
| 8281242 | 570319 | Railside Danny Boy Red Ale | Railside Brewing | Irish Ale | 3.3 | 2018-07-15 | 7 | 15 | 2018 |
| 8281243 | 570319 | Old Ivy My Favorite Marzen | Old Ivy Brewery | Oktoberfest/Märzen | 4.1 | 2018-07-15 | 7 | 15 | 2018 |
| 8281244 | 570319 | Brothers Cascadia IPA | Brothers Cascadia Brewing | India Pale Ale (IPA) | 3.5 | 2018-07-15 | 7 | 15 | 2018 |
| 8281245 | 570319 | Old Ivy Hoppy Toppy Red Ale | Old Ivy Brewery | Amber Ale | 4.0 | 2018-07-15 | 7 | 15 | 2018 |
8281246 rows × 9 columns
In [2]:
U=df['user'].unique()
In [3]:
T=[]
for i in U:
t=df[df['user']==i].tail()
T.append(t)
Train=pd.concat(T)
Train
Out[3]:
| user | beer_name | brewery | beer_style | score | date | 월 | 일 | 년 | |
|---|---|---|---|---|---|---|---|---|---|
| 54 | 2 | Sweetwater ESB | Sweetwater Brewing Company | Premium Bitter/ESB | 3.4 | 2001-11-12 | 11 | 12 | 2001 |
| 55 | 2 | Sweetwater 420 Extra Pale Ale | Sweetwater Brewing Company | American Pale Ale | 4.1 | 2001-11-12 | 11 | 12 | 2001 |
| 56 | 2 | Sweetwater Blue | Sweetwater Brewing Company | Fruit Beer | 4.1 | 2001-11-12 | 11 | 12 | 2001 |
| 57 | 2 | Carolina Beer Co. Cottonwood Endo India Pale Ale | Carolina Beer Company | India Pale Ale (IPA) | 4.4 | 2002-10-23 | 10 | 23 | 2002 |
| 58 | 2 | Monks Café Kaffeportern | Monks Café Stockholm | Porter | 3.0 | 2010-09-25 | 9 | 25 | 2010 |
| 301 | 3 | Granite City The Duke | Granite City Food & Brewery | American Pale Ale | 2.2 | 2012-03-17 | 3 | 17 | 2012 |
| 302 | 3 | Lancaster Amish Four Grain Ale | Lancaster Brewing Co. | American Pale Ale | 2.8 | 2012-03-17 | 3 | 17 | 2012 |
| 303 | 3 | New Holland Imperial Hatter | New Holland Brewing Company | Imperial IPA | 4.2 | 2013-04-27 | 4 | 27 | 2013 |
| 304 | 3 | Burnt Hickory The Fighting Bishop | Burnt Hickory Brewery | Abbey Tripel | 3.9 | 2015-09-08 | 9 | 8 | 2015 |
| 305 | 3 | Jekyll Hop Dang Diggity Southern IPA | Jekyll Brewing | India Pale Ale (IPA) | 4.0 | 2016-10-12 | 10 | 12 | 2016 |
| 2954 | 46 | Kiper Pilsner Classic | Sulimar - Browar Cornelius | Pilsener | 3.0 | 2007-12-13 | 12 | 13 | 2007 |
| 2955 | 46 | Hook Norton Twelve Days (Bottle) | Hook Norton | English Strong Ale | 3.8 | 2007-12-13 | 12 | 13 | 2007 |
| 2956 | 46 | HaandBryggeriet Porter | HaandBryggeriet (Norway) | Porter | 4.2 | 2007-12-13 | 12 | 13 | 2007 |
| 2957 | 46 | Caballo Cerveza Extra | Cerveceria La Constancia (AB InBev) | Pale Lager | 2.0 | 2007-12-13 | 12 | 13 | 2007 |
| 2958 | 46 | Monks Café Kaffeportern | Monks Café Stockholm | Porter | 3.0 | 2010-09-17 | 9 | 17 | 2010 |
| 3055 | 57 | Samuel Adams Old Fezziwig Ale | Boston Beer Company | Spice/Herb/Vegetable | 3.7 | 2001-01-10 | 1 | 10 | 2001 |
| 3056 | 57 | Allagash Dubbel Reserve | Allagash Brewing Company | Abbey Dubbel | 3.5 | 2001-01-14 | 1 | 14 | 2001 |
| 3057 | 57 | Bell's Midwestern Pale Ale | Bell's Brewery | American Pale Ale | 4.5 | 2001-01-14 | 1 | 14 | 2001 |
| 3058 | 57 | Great Lakes Eliot Ness | Great Lakes Brewing (Ohio) | Amber Lager/Vienna | 4.4 | 2001-01-14 | 1 | 14 | 2001 |
| 3059 | 57 | Great Lakes Edmund Fitzgerald Porter | Great Lakes Brewing (Ohio) | Porter | 4.4 | 2001-01-14 | 1 | 14 | 2001 |
| 6571 | 63 | Bale Breaker Topcutter IPA | Bale Breaker Brewing Company | India Pale Ale (IPA) | 3.8 | 2017-03-20 | 3 | 20 | 2017 |
| 6572 | 63 | Left Hand Hard Wired Nitro Coffee Porter | Left Hand Brewing Company | Porter | 3.3 | 2017-03-20 | 3 | 20 | 2017 |
| 6573 | 63 | Toppling Goliath Pompeii IPA | Toppling Goliath Brewing Company | India Pale Ale (IPA) | 4.0 | 2017-03-20 | 3 | 20 | 2017 |
| 6574 | 63 | Left Hand Well Played Red IPA | Left Hand Brewing Company | India Pale Ale (IPA) | 3.9 | 2017-03-21 | 3 | 21 | 2017 |
| 6575 | 63 | Silver Moon Crazy Horse Imperial IPA | Silver Moon Brewing | Imperial IPA | 2.9 | 2017-03-25 | 3 | 25 | 2017 |
| 6682 | 65 | Appalachian Water Gap Wheat | Appalachian Brewing Company (PA) | Wheat Ale | 2.2 | 2002-07-24 | 7 | 24 | 2002 |
| 6683 | 65 | Appalachian Riverside Red Ale | Appalachian Brewing Company (PA) | Amber Ale | 2.8 | 2002-07-24 | 7 | 24 | 2002 |
| 6684 | 65 | Appalachian Purist Pale Ale | Appalachian Brewing Company (PA) | American Pale Ale | 3.1 | 2002-07-24 | 7 | 24 | 2002 |
| 6685 | 65 | Appalachian Mountain Lager | Appalachian Brewing Company (PA) | Dortmunder/Helles | 3.0 | 2002-07-24 | 7 | 24 | 2002 |
| 6686 | 65 | Appalachian Anniversary Maibock | Appalachian Brewing Company (PA) | Heller Bock | 3.6 | 2002-07-24 | 7 | 24 | 2002 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8280496 | 568034 | Cucapá Honey | Cervecería Cucapá | Amber Ale | 2.5 | 2018-07-18 | 7 | 18 | 2018 |
| 8280497 | 568034 | Cucapá Obscura | Cervecería Cucapá | Brown Ale | 2.5 | 2018-07-18 | 7 | 18 | 2018 |
| 8280498 | 568034 | Cucapá Chupacabras Pale Ale | Cervecería Cucapá | American Pale Ale | 2.5 | 2018-07-18 | 7 | 18 | 2018 |
| 8280499 | 568034 | Weihenstephaner Korbinian | Bayerische Staatsbrauerei Weihenstephan | Doppelbock | 4.7 | 2018-07-18 | 7 | 18 | 2018 |
| 8280500 | 568034 | Belhaven Scottish Oat Stout | Belhaven (Greene King) | Sweet Stout | 4.2 | 2018-07-20 | 7 | 20 | 2018 |
| 8280935 | 568064 | Adnams Broadside (Bottle) | Adnams | English Strong Ale | 3.1 | 2018-07-20 | 7 | 20 | 2018 |
| 8280936 | 568064 | Struise Svea IPA | De Struise Brouwers | India Pale Ale (IPA) | 3.4 | 2018-07-21 | 7 | 21 | 2018 |
| 8280937 | 568064 | Struise Rosse | De Struise Brouwers | Belgian Ale | 3.1 | 2018-07-21 | 7 | 21 | 2018 |
| 8280938 | 568064 | Struise Witte | De Struise Brouwers | Witbier | 2.8 | 2018-07-21 | 7 | 21 | 2018 |
| 8280939 | 568064 | Struise Pannepot Grand Reserva | De Struise Brouwers | Belgian Strong Ale | 4.1 | 2018-07-21 | 7 | 21 | 2018 |
| 8280993 | 568998 | Delirium Red | Brouwerij Huyghe | Fruit Beer | 3.3 | 2018-06-27 | 6 | 27 | 2018 |
| 8280994 | 568998 | Leffe Ruby | Anheuser-Busch InBev Belgium (AB InBev) | Fruit Beer | 2.8 | 2018-06-27 | 6 | 27 | 2018 |
| 8280995 | 568998 | Oud Beersel Oude Kriek | Brouwerij Oud Beersel | Lambic Style - Fruit | 4.0 | 2018-06-30 | 6 | 30 | 2018 |
| 8280996 | 568998 | De Halve Maan Straffe Hendrik Brugs Tripelbier 9° | Huisbrouwerij De Halve Maan | Abbey Tripel | 4.0 | 2018-07-01 | 7 | 1 | 2018 |
| 8280997 | 568998 | Verhaeghe Echt Kriekenbier | Verhaeghe | Sour/Wild Ale | 3.3 | 2018-07-05 | 7 | 5 | 2018 |
| 8281047 | 569050 | La Trappe Tripel | La Trappe Trappist - Abdij O.L.V. Koningshoeve... | Abbey Tripel | 3.5 | 2018-07-17 | 7 | 17 | 2018 |
| 8281048 | 569050 | Robinsons Trooper Red 'n' Black (Bottle) | Robinsons | Porter | 3.2 | 2018-07-17 | 7 | 17 | 2018 |
| 8281049 | 569050 | Lazy Magnolia Sweet Potato Stout | Lazy Magnolia Brewing Company | Sweet Stout | 3.4 | 2018-07-17 | 7 | 17 | 2018 |
| 8281050 | 569050 | Paulaner Salvator | Paulaner Brauerei (Schörghuber) | Doppelbock | 3.5 | 2018-07-19 | 7 | 19 | 2018 |
| 8281051 | 569050 | Abita Amber Lager | Abita Brewing Company | Amber Lager/Vienna | 3.3 | 2018-07-19 | 7 | 19 | 2018 |
| 8281178 | 569699 | Fat Lizard Ankle Slapper Surf Ale | Fat Lizard Brewing Co. | American Pale Ale | 3.8 | 2018-07-18 | 7 | 18 | 2018 |
| 8281179 | 569699 | Shepherd Neame Bishops Finger (Pasteurised) | Shepherd Neame | Premium Bitter/ESB | 3.2 | 2018-07-19 | 7 | 19 | 2018 |
| 8281180 | 569699 | Flying Dog Doggie Style Pale Ale | Flying Dog Brewery | American Pale Ale | 3.4 | 2018-07-20 | 7 | 20 | 2018 |
| 8281181 | 569699 | Chouffe Houblon Dobbelen IPA Tripel | Brasserie d'Achouffe (Duvel-Moortgat) | Belgian Strong Ale | 4.0 | 2018-07-20 | 7 | 20 | 2018 |
| 8281182 | 569699 | St. Barley Ginger Pale Ale | St. Barley | Spice/Herb/Vegetable | 3.0 | 2018-07-20 | 7 | 20 | 2018 |
| 8281241 | 570319 | Railside Trestle NW IPA | Railside Brewing | India Pale Ale (IPA) | 3.7 | 2018-07-15 | 7 | 15 | 2018 |
| 8281242 | 570319 | Railside Danny Boy Red Ale | Railside Brewing | Irish Ale | 3.3 | 2018-07-15 | 7 | 15 | 2018 |
| 8281243 | 570319 | Old Ivy My Favorite Marzen | Old Ivy Brewery | Oktoberfest/Märzen | 4.1 | 2018-07-15 | 7 | 15 | 2018 |
| 8281244 | 570319 | Brothers Cascadia IPA | Brothers Cascadia Brewing | India Pale Ale (IPA) | 3.5 | 2018-07-15 | 7 | 15 | 2018 |
| 8281245 | 570319 | Old Ivy Hoppy Toppy Red Ale | Old Ivy Brewery | Amber Ale | 4.0 | 2018-07-15 | 7 | 15 | 2018 |
51885 rows × 9 columns
In [5]:
Train.to_csv('finally_beer_Train.csv',index=False)
In [13]:
V=[]
for i in U:
v=df[df['user']==i][-10:-5]
V.append(v)
Validation=pd.concat(V)
Validation
Out[13]:
| user | beer_name | brewery | beer_style | score | date | 월 | 일 | 년 | |
|---|---|---|---|---|---|---|---|---|---|
| 49 | 2 | St. Sebastiaan Dark | Brouwerij Sterkens | Abbey Dubbel | 4.5 | 2000-10-16 | 10 | 16 | 2000 |
| 50 | 2 | John Courage | John Smiths (Heineken UK) | Premium Bitter/ESB | 3.4 | 2000-10-19 | 10 | 19 | 2000 |
| 51 | 2 | Fuller's London Pride (Filtered) | Fuller's | Premium Bitter/ESB | 3.6 | 2000-11-26 | 11 | 26 | 2000 |
| 52 | 2 | Ayinger Celebrator Doppelbock | Brauerei Aying | Doppelbock | 4.4 | 2000-12-01 | 12 | 1 | 2000 |
| 53 | 2 | Hitachino Nest White Ale | Kiuchi Brewery (Hitachino) | Witbier | 2.1 | 2001-11-12 | 11 | 12 | 2001 |
| 296 | 3 | Monks Café Kaffeportern | Monks Café Stockholm | Porter | 3.0 | 2010-10-19 | 10 | 19 | 2010 |
| 297 | 3 | Southern Tier 2XIPA | Southern Tier Brewing Company (ABV) | Imperial IPA | 3.4 | 2011-02-05 | 2 | 5 | 2011 |
| 298 | 3 | Sebago Frye's Leap IPA | Sebago Brewing Company | India Pale Ale (IPA) | 3.3 | 2011-12-24 | 12 | 24 | 2011 |
| 299 | 3 | Lagunitas Sonoma Farmhouse Hop Stoopid | Lagunitas Brewing Company (Heineken) | Imperial IPA | 4.5 | 2011-12-24 | 12 | 24 | 2011 |
| 300 | 3 | Diamond Bear Paradise Porter | Diamond Bear Brewing Company | Porter | 3.2 | 2011-12-24 | 12 | 24 | 2011 |
| 2949 | 46 | Saison Imperiale | De Proefbrouwerij | Saison | 3.9 | 2007-12-05 | 12 | 5 | 2007 |
| 2950 | 46 | Ridgeway Insanely Bad Elf | Ridgeway Brewing | Barley Wine | 3.8 | 2007-12-13 | 12 | 13 | 2007 |
| 2951 | 46 | Nøgne Ø God Jul | Nøgne Ø (Hansa Borg) | American Strong Ale | 4.3 | 2007-12-13 | 12 | 13 | 2007 |
| 2952 | 46 | Nøgne Ø Brown Ale | Nøgne Ø (Hansa Borg) | Brown Ale | 4.1 | 2007-12-13 | 12 | 13 | 2007 |
| 2953 | 46 | Mikkeller Stateside | Mikkeller | India Pale Ale (IPA) | 4.1 | 2007-12-13 | 12 | 13 | 2007 |
| 3050 | 57 | La Trappe Quadrupel | La Trappe Trappist - Abdij O.L.V. Koningshoeve... | Abt/Quadrupel | 3.6 | 2001-01-07 | 1 | 7 | 2001 |
| 3051 | 57 | Unibroue Trois Pistoles | Unibroue (Sapporo) | Abt/Quadrupel | 4.2 | 2001-01-07 | 1 | 7 | 2001 |
| 3052 | 57 | Arrogant Bastard Ale | Arrogant Brewing | American Strong Ale | 4.1 | 2001-01-07 | 1 | 7 | 2001 |
| 3053 | 57 | Corsendonk Christmas Ale | Brouwerij Corsendonk | Belgian Strong Ale | 4.0 | 2001-01-10 | 1 | 10 | 2001 |
| 3054 | 57 | Rochefort Trappistes 10 | Brasserie Rochefort | Abt/Quadrupel | 4.3 | 2001-01-10 | 1 | 10 | 2001 |
| 6566 | 63 | Clown Shoes Chocolate Sombrero | Clown Shoes Beer (Harpoon Brewery) | Imperial Stout | 3.5 | 2016-01-22 | 1 | 22 | 2016 |
| 6567 | 63 | Chris Banker / Insurgente / Stone Xocoveza Moc... | Stone Brewing | Imperial Stout | 4.4 | 2016-02-05 | 2 | 5 | 2016 |
| 6568 | 63 | Epic Big Bad Baptist | Epic Brewing Company (UT/CO) | Imperial Stout | 4.5 | 2016-07-18 | 7 | 18 | 2016 |
| 6569 | 63 | Hopworks Ferocious Citrus IPA | Hopworks Urban Brewery | India Pale Ale (IPA) | 3.3 | 2017-03-20 | 3 | 20 | 2017 |
| 6570 | 63 | Slanted Rock Initial Point IPA | Slanted Rock Brewing Company | India Pale Ale (IPA) | 3.1 | 2017-03-20 | 3 | 20 | 2017 |
| 6677 | 65 | Weyerbacher Blithering Idiot | Weyerbacher Brewing Co. | Barley Wine | 2.8 | 2002-05-20 | 5 | 20 | 2002 |
| 6678 | 65 | Appalachian Mad Cameron Belgian White | Appalachian Brewing Company (PA) | Witbier | 2.4 | 2002-07-24 | 7 | 24 | 2002 |
| 6679 | 65 | Appalachian Susquehanna Stout | Appalachian Brewing Company (PA) | Dry Stout | 3.7 | 2002-07-24 | 7 | 24 | 2002 |
| 6680 | 65 | Appalachian Hinterland Hefe Weizen | Appalachian Brewing Company (PA) | German Hefeweizen | 3.2 | 2002-07-24 | 7 | 24 | 2002 |
| 6681 | 65 | Appalachian Jolly Scot Scottish Ale | Appalachian Brewing Company (PA) | Scottish Ale | 3.9 | 2002-07-24 | 7 | 24 | 2002 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8280491 | 568034 | Fauna Mala Vida | Cerveceria Fauna | Belgian Ale | 3.5 | 2018-07-16 | 7 | 16 | 2018 |
| 8280492 | 568034 | Bracino Tiki Session | Bracino Cerveceria | Golden Ale/Blond Ale | 2.5 | 2018-07-17 | 7 | 17 | 2018 |
| 8280493 | 568034 | Bass Pale Ale (USA and export) | Anheuser-Busch InBev (AB InBev) | Premium Bitter/ESB | 3.7 | 2018-07-18 | 7 | 18 | 2018 |
| 8280494 | 568034 | Cucapá Ámbar | Cervecería Cucapá | Amber Ale | 2.5 | 2018-07-18 | 7 | 18 | 2018 |
| 8280495 | 568034 | Cucapá Clasica | Cervecería Cucapá | Golden Ale/Blond Ale | 2.5 | 2018-07-18 | 7 | 18 | 2018 |
| 8280930 | 568064 | Ayinger Celebrator Doppelbock | Brauerei Aying | Doppelbock | 3.7 | 2018-07-20 | 7 | 20 | 2018 |
| 8280931 | 568064 | Anchor Old Foghorn Ale | Anchor Brewing Company (Sapporo) | Barley Wine | 4.2 | 2018-07-20 | 7 | 20 | 2018 |
| 8280932 | 568064 | Alfa Midzomer Bier | Alfa Bierbrouwerij | Golden Ale/Blond Ale | 2.9 | 2018-07-20 | 7 | 20 | 2018 |
| 8280933 | 568064 | Alaskan Amber | Alaskan Brewing Company | Altbier | 3.3 | 2018-07-20 | 7 | 20 | 2018 |
| 8280934 | 568064 | Aecht Schlenkerla Rauchbier Märzen | Brauerei Heller | Smoked | 3.2 | 2018-07-20 | 7 | 20 | 2018 |
| 8280988 | 568998 | Lindemans Pêche Lambic (Pêcheresse) | Brouwerij Lindemans | Lambic Style - Fruit | 4.0 | 2018-06-27 | 6 | 27 | 2018 |
| 8280989 | 568998 | Barbãr | Brasserie Lefebvre | Belgian Strong Ale | 1.0 | 2018-06-27 | 6 | 27 | 2018 |
| 8280990 | 568998 | De Halve Maan Brugse Zot Dubbel | Huisbrouwerij De Halve Maan | Abbey Dubbel | 3.0 | 2018-06-27 | 6 | 27 | 2018 |
| 8280991 | 568998 | Tripel Karmeliet | Brouwerij Bosteels (AB InBev) | Abbey Tripel | 4.0 | 2018-06-27 | 6 | 27 | 2018 |
| 8280992 | 568998 | Bacchus Kriekenbier | Brouwerij Van Honsebrouck | Sour Red/Brown | 3.0 | 2018-06-27 | 6 | 27 | 2018 |
| 8281042 | 569050 | North Coast Old Rasputin (Bourbon Barrel) | North Coast Brewing Company | Imperial Stout | 4.5 | 2018-07-07 | 7 | 7 | 2018 |
| 8281043 | 569050 | Evil Twin Yin | Evil Twin Brewing | Imperial Stout | 3.5 | 2018-07-11 | 7 | 11 | 2018 |
| 8281044 | 569050 | Anderson Valley Barney Flats Oatmeal Stout | Anderson Valley Brewing Company | Stout | 2.9 | 2018-07-13 | 7 | 13 | 2018 |
| 8281045 | 569050 | Evil Twin Nasty Trunks (Batch #001) | Evil Twin Brewing | Sour/Wild Ale | 1.5 | 2018-07-13 | 7 | 13 | 2018 |
| 8281046 | 569050 | Fuller's Past Masters 1905 Old London Ale | Fuller's | English Strong Ale | 3.5 | 2018-07-13 | 7 | 13 | 2018 |
| 8281173 | 569699 | Brooklyn East IPA / India Pale Ale | Brooklyn Brewery | India Pale Ale (IPA) | 4.0 | 2018-07-14 | 7 | 14 | 2018 |
| 8281174 | 569699 | Mathildedalin Dorf | Mathildedalin Kyläpanimo | Pilsener | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281175 | 569699 | Monteiths (DB Breweries) Highway 6 IPA | Monteiths Brewing Co. (DB Breweries) | India Pale Ale (IPA) | 3.3 | 2018-07-15 | 7 | 15 | 2018 |
| 8281176 | 569699 | BrewDog Punk IPA (5.6%) | BrewDog | India Pale Ale (IPA) | 4.1 | 2018-07-15 | 7 | 15 | 2018 |
| 8281177 | 569699 | Gotlands Sitting Bulldog IPA | Gotlands Bryggeri (Spendrups) | India Pale Ale (IPA) | 3.1 | 2018-07-18 | 7 | 18 | 2018 |
| 8281236 | 570319 | Loowit Super Ninja | Loowit Brewing Company | Imperial IPA | 4.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281237 | 570319 | Loowit Two-Sixteen Red Ale | Loowit Brewing Company | Amber Ale | 4.5 | 2018-07-14 | 7 | 14 | 2018 |
| 8281238 | 570319 | Loowit Shadow Shinobi IPA | Loowit Brewing Company | India Pale Ale (IPA) | 4.4 | 2018-07-14 | 7 | 14 | 2018 |
| 8281239 | 570319 | Victor 23 Terminal Velocity | Victor 23 Brewing | Specialty Grain | 3.4 | 2018-07-15 | 7 | 15 | 2018 |
| 8281240 | 570319 | Victor 23 Jet Fuel Imperial IPA | Victor 23 Brewing | Imperial IPA | 3.9 | 2018-07-15 | 7 | 15 | 2018 |
51885 rows × 9 columns
In [14]:
Tr=[]
for i in U:
tr=df[df['user']==i][:-10]
Tr.append(tr)
Train=pd.concat(Tr)
Train
Out[14]:
| user | beer_name | brewery | beer_style | score | date | 월 | 일 | 년 | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | Worthington's White Shield | Molson Coors UK (Molson Coors) | Premium Bitter/ESB | 4.4 | 2000-04-16 | 4 | 16 | 2000 |
| 1 | 2 | Rogue Dry Hopped St. Rogue Red Ale | Rogue Ales | Amber Ale | 4.3 | 2000-04-23 | 4 | 23 | 2000 |
| 2 | 2 | Maclay Oat Malt Stout | Clockwork (Maclay) | Stout | 2.4 | 2000-04-28 | 4 | 28 | 2000 |
| 3 | 2 | Newcastle Brown Ale | Heineken Nederland | Brown Ale | 3.9 | 2000-04-28 | 4 | 28 | 2000 |
| 4 | 2 | Rogue Mocha Porter | Rogue Ales | Porter | 4.9 | 2000-04-28 | 4 | 28 | 2000 |
| 5 | 2 | Flying Dog Doggie Style Pale Ale | Flying Dog Brewery | American Pale Ale | 4.4 | 2000-04-28 | 4 | 28 | 2000 |
| 6 | 2 | Fuller's India Pale Ale (Bottle/Keg) | Fuller's | India Pale Ale (IPA) | 3.5 | 2000-04-28 | 4 | 28 | 2000 |
| 7 | 2 | Samuel Adams Pale Ale | Boston Beer Company | English Pale Ale | 3.6 | 2000-05-03 | 5 | 3 | 2000 |
| 8 | 2 | Dogwood Breakdown IPA | Dogwood Brewing Company (GA) | India Pale Ale (IPA) | 4.3 | 2000-05-03 | 5 | 3 | 2000 |
| 9 | 2 | King and Barnes IPA | King and Barnes | Premium Bitter/ESB | 4.3 | 2000-05-03 | 5 | 3 | 2000 |
| 10 | 2 | Sweetwater IPA | Sweetwater Brewing Company | India Pale Ale (IPA) | 4.3 | 2000-05-03 | 5 | 3 | 2000 |
| 11 | 2 | Samuel Smiths India Ale | Samuel Smith | Premium Bitter/ESB | 3.5 | 2000-05-03 | 5 | 3 | 2000 |
| 12 | 2 | Samuel Smiths Organic / Old Brewery Pale Ale | Samuel Smith | Premium Bitter/ESB | 4.5 | 2000-05-03 | 5 | 3 | 2000 |
| 13 | 2 | Dogwood Pale Ale | Dogwood Brewing Company (GA) | English Pale Ale | 3.5 | 2000-05-03 | 5 | 3 | 2000 |
| 14 | 2 | Boddingtons Pub Ale (Can) | Samlesbury (AB InBev UK) | Bitter | 2.8 | 2000-05-03 | 5 | 3 | 2000 |
| 15 | 2 | Ruddles County (Filtered) | Greene King | Premium Bitter/ESB | 3.6 | 2000-05-03 | 5 | 3 | 2000 |
| 16 | 2 | Redhook ESB | Redhook Brewery | Premium Bitter/ESB | 1.9 | 2000-05-03 | 5 | 3 | 2000 |
| 17 | 2 | North Coast Red Seal Ale | North Coast Brewing Company | American Pale Ale | 4.2 | 2000-05-03 | 5 | 3 | 2000 |
| 18 | 2 | Grolsch Amber Ale | Grolsche Bierbrouwerij Ned. (Asahi) | Amber Ale | 3.5 | 2000-05-03 | 5 | 3 | 2000 |
| 19 | 2 | Rogue Nation Brutal India Pale Ale | Rogue Ales | India Pale Ale (IPA) | 4.7 | 2000-05-03 | 5 | 3 | 2000 |
| 20 | 2 | Rogue HazelNut Brown Nectar | Rogue Ales | Brown Ale | 4.4 | 2000-05-03 | 5 | 3 | 2000 |
| 21 | 2 | Flying Dog Snake Dog IPA (through 2007) | Flying Dog Brewery | India Pale Ale (IPA) | 2.9 | 2000-05-04 | 5 | 4 | 2000 |
| 22 | 2 | Guinness Draught | St. James's Gate (Diageo) | Dry Stout | 4.7 | 2000-05-10 | 5 | 10 | 2000 |
| 23 | 2 | Samuel Adams Boston Ale | Boston Beer Company | Amber Ale | 3.6 | 2000-05-19 | 5 | 19 | 2000 |
| 24 | 2 | Heineken | Heineken Nederland | Pale Lager | 1.9 | 2000-05-23 | 5 | 23 | 2000 |
| 25 | 2 | Harpoon Pilsner | Harpoon Brewery | Pilsener | 2.8 | 2000-05-23 | 5 | 23 | 2000 |
| 26 | 2 | Harpoon Dark | Harpoon Brewery | Dunkel/Tmavý | 4.0 | 2000-05-25 | 5 | 25 | 2000 |
| 27 | 2 | Harpoon Ale | Harpoon Brewery | Amber Ale | 4.2 | 2000-05-25 | 5 | 25 | 2000 |
| 28 | 2 | Paulaner Hefe-Weissbier (Hefe-Weizen) (5.5%) | Paulaner Brauerei (Schörghuber) | German Hefeweizen | 4.7 | 2000-05-28 | 5 | 28 | 2000 |
| 29 | 2 | Tuppers Hop Pocket Ale | Tuppers' Hop Pocket Beers | American Pale Ale | 3.1 | 2000-05-28 | 5 | 28 | 2000 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 8281206 | 570319 | New Belgium Ranger IPA | New Belgium Brewing Company | India Pale Ale (IPA) | 4.5 | 2018-07-08 | 7 | 8 | 2018 |
| 8281207 | 570319 | New Belgium Voodoo Ranger IPA | New Belgium Brewing Company | India Pale Ale (IPA) | 4.1 | 2018-07-08 | 7 | 8 | 2018 |
| 8281208 | 570319 | New Belgium Voodoo Ranger 8 Hop Pale Ale | New Belgium Brewing Company | American Pale Ale | 3.8 | 2018-07-08 | 7 | 8 | 2018 |
| 8281209 | 570319 | New Belgium Fat Tire | New Belgium Brewing Company | Amber Ale | 4.5 | 2018-07-08 | 7 | 8 | 2018 |
| 8281210 | 570319 | Powell Old Jalopy Pale Ale | Powell Brewery | English Pale Ale | 4.0 | 2018-07-08 | 7 | 8 | 2018 |
| 8281211 | 570319 | Sierra Nevada Torpedo Extra IPA | Sierra Nevada Brewing Company | India Pale Ale (IPA) | 4.4 | 2018-07-08 | 7 | 8 | 2018 |
| 8281212 | 570319 | Sierra Nevada Southern Hemisphere IPA | Sierra Nevada Brewing Company | India Pale Ale (IPA) | 4.0 | 2018-07-08 | 7 | 8 | 2018 |
| 8281213 | 570319 | Sierra Nevada Bigfoot | Sierra Nevada Brewing Company | Barley Wine | 4.1 | 2018-07-08 | 7 | 8 | 2018 |
| 8281214 | 570319 | Sierra Nevada / Faust Oktoberfest (2017) | Sierra Nevada Brewing Company | Oktoberfest/Märzen | 4.5 | 2018-07-08 | 7 | 8 | 2018 |
| 8281215 | 570319 | Old Ivy Rediculous Red Ale | Old Ivy Brewery | Amber Ale | 4.3 | 2018-07-08 | 7 | 8 | 2018 |
| 8281216 | 570319 | Lawson's Finest Sip of Sunshine IPA | Lawson's Finest Liquids | Imperial IPA | 5.0 | 2018-07-08 | 7 | 8 | 2018 |
| 8281217 | 570319 | 7 Devils Double Hop IPA | 7 Devils Brewing Company | India Pale Ale (IPA) | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281218 | 570319 | Four Peaks Peach Ale | Four Peaks Brewing Company (AB InBev) | Fruit Beer | 3.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281219 | 570319 | Scottsdale Beer Co. Easy Amber | Scottsdale Beer Company | Amber Ale | 3.4 | 2018-07-14 | 7 | 14 | 2018 |
| 8281220 | 570319 | Scottsdale Beer Co. Big O Irish Red | Scottsdale Beer Company | Irish Ale | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281221 | 570319 | Scottsdale Beer Co. Galactic IPA | Scottsdale Beer Company | India Pale Ale (IPA) | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281222 | 570319 | 54°40' Or Fight | 54°40' Brewing Company | Black IPA | 3.2 | 2018-07-14 | 7 | 14 | 2018 |
| 8281223 | 570319 | 54°40' Käscadia Kölsch | 54°40' Brewing Company | Kölsch | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281224 | 570319 | Rentsch IPA | Rentsch Brewery | India Pale Ale (IPA) | 3.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281225 | 570319 | Kona Longboard Island Lager | Kona Brewing Company | Pale Lager | 3.5 | 2018-07-14 | 7 | 14 | 2018 |
| 8281226 | 570319 | Too Sticky To Roll (NW IRA) | Burnside Brewing Company (OR) | India Pale Ale (IPA) | 4.5 | 2018-07-14 | 7 | 14 | 2018 |
| 8281227 | 570319 | Burnside Sweet Heat | Burnside Brewing Company (OR) | Spice/Herb/Vegetable | 3.9 | 2018-07-14 | 7 | 14 | 2018 |
| 8281228 | 570319 | Rogue Farms 10 Hop IPA | Rogue Ales | Imperial IPA | 4.4 | 2018-07-14 | 7 | 14 | 2018 |
| 8281229 | 570319 | Rogue Dead Guy Ale | Rogue Ales | Heller Bock | 4.2 | 2018-07-14 | 7 | 14 | 2018 |
| 8281230 | 570319 | Lagunitas Undercover Investigation Shut-Down Ale | Lagunitas Brewing Company (Heineken) | American Strong Ale | 4.8 | 2018-07-14 | 7 | 14 | 2018 |
| 8281231 | 570319 | Lagunitas A Little Sumpin' Sumpin' Ale | Lagunitas Brewing Company (Heineken) | India Pale Ale (IPA) | 4.1 | 2018-07-14 | 7 | 14 | 2018 |
| 8281232 | 570319 | Everybody's Tiny Tank Series: On That Dust IPA | Everybody's Brewing | India Pale Ale (IPA) | 4.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281233 | 570319 | Everybody's Local Logger Lager | Everybody's Brewing | Premium Lager | 3.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281234 | 570319 | No-Li Komrade | No-Li Brewhouse | Imperial IPA | 4.7 | 2018-07-14 | 7 | 14 | 2018 |
| 8281235 | 570319 | Lagunitas Lucky 13 | Lagunitas Brewing Company (Heineken) | American Strong Ale | 4.8 | 2018-07-14 | 7 | 14 | 2018 |
8177476 rows × 9 columns
In [15]:
Validation.to_csv('finally_beer_Validation.csv',index=False)
In [16]:
Train.to_csv('finally_beer_Train.csv',index=False)
'beginner > 파이썬 분석' 카테고리의 다른 글
| 서울시 구별 CCTV 현황 분석-2 (0) | 2019.06.28 |
|---|---|
| 서울시 구별 CCTV 현황 분석-1 (1) | 2019.06.27 |
| 맥주데이터 추천시스템_4/22 (0) | 2019.04.22 |
| 캐글 타이타닉 데이터 분석 - 2 (1) | 2019.04.12 |
| 캐글 타이타닉 데이터 분석 - 1 (0) | 2019.04.11 |