Kernel: Python 3 (system-wide)
In [1]:
Reviews Deutsch
In [2]:
| text | |
|---|---|
| 0 | martinawernliZurich, Switzerland174Reviewed Ma... |
| 1 | beatrixx123Zurich, Switzerland24082Reviewed Ap... |
| 2 | birgittk_12Delmenhorst, Germany9452Reviewed Oc... |
| 3 | darklordmanu1Reviewed November 11, 2018 Ein Ho... |
| 4 | Vychen2013Zürich126Reviewed March 11, 2016 via... |
| ... | ... |
| 549 | Tina SZurich, Switzerland1015Reviewed January ... |
| 550 | lbruelhartZurich, Switzerland8332Reviewed Augu... |
| 551 | turimutterOberrohrdorf, Switzerland334143Revie... |
| 552 | chrigi1974Horgen, Switzerland5Reviewed October... |
| 553 | BrunoS774644Reviewed May 1, 2017 via mobile Mi... |
554 rows × 1 columns
In [3]:
| text | |
|---|---|
| 0 | martinawernliZurich, Switzerland174Reviewed Ma... |
| 1 | beatrixx123Zurich, Switzerland24082Reviewed Ap... |
| 2 | birgittk_12Delmenhorst, Germany9452Reviewed Oc... |
| 3 | darklordmanu1Reviewed November 11, 2018 Ein Ho... |
| 4 | Vychen2013Zürich126Reviewed March 11, 2016 via... |
| ... | ... |
| 549 | Tina SZurich, Switzerland1015Reviewed January ... |
| 550 | lbruelhartZurich, Switzerland8332Reviewed Augu... |
| 551 | turimutterOberrohrdorf, Switzerland334143Revie... |
| 552 | chrigi1974Horgen, Switzerland5Reviewed October... |
| 553 | BrunoS774644Reviewed May 1, 2017 via mobile Mi... |
554 rows × 1 columns
In [4]:
False
In [5]:
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | martinawernliZurich, Switzerland174 | March 13, 2017 Vegi-MetzgGoogle Translation I... | May 3, 2017Google Translation Herzlichen Dank... |
| 1 | beatrixx123Zurich, Switzerland24082 | April 21, 2016 Lohnenswerter Besuch einfach s... | April 23, 2016Google Translation Vielen Dank ... |
| 2 | birgittk_12Delmenhorst, Germany9452 | October 3, 2012 Super, kaum zu Glauben das es... | November 18, 2012Google Translation Danke für... |
| 3 | darklordmanu1 | November 11, 2018 Ein Hoch auf HiltlGoogle Tr... | November 11, 2018Google Translation Lieber da... |
| 4 | Vychen2013Zürich126 | March 11, 2016 via mobile Gute SmoothiesGoogl... | March 14, 2016Google Translation Vielen Dank ... |
| ... | ... | ... | ... |
| 549 | Tina SZurich, Switzerland1015 | January 18, 2018 LeckerGoogle Translation Imm... | February 8, 2018Google Translation Liebe Tina... |
| 550 | lbruelhartZurich, Switzerland8332 | August 12, 2012 Das beste was es gibt!Google ... | August 14, 2012Google Translation Vielen Dank... |
| 551 | turimutterOberrohrdorf, Switzerland334143 | March 2, 2017 Gesund und schmackhaftGoogle Tr... | May 10, 2017Google Translation Auch für uns i... |
| 552 | chrigi1974Horgen, Switzerland5 | October 21, 2010 Vegetarisch? So schon...Goog... | None |
| 553 | BrunoS774644 | May 1, 2017 via mobile Mittag und AbendGoogle... | May 2, 2017Google Translation Ein riesen gros... |
554 rows × 3 columns
In [6]:
In [7]:
| text | |
|---|---|
| 0 | Melli10Zurich, Switzerland8167Reviewed October... |
| 1 | MMKKMMKK813Reviewed May 4, 2013 via mobile Run... |
| 2 | BaudimZurich, Switzerland423248Reviewed April ... |
| 3 | stephkellZurich, Switzerland258Reviewed Septem... |
| 4 | Maxime587Zurich, Switzerland17643Reviewed Janu... |
| ... | ... |
| 347 | Dorothea MZürich, Zurich, Switzerland53Reviewe... |
| 348 | just_1_classyZurich, Switzerland194131Reviewed... |
| 349 | Tauriel1989Zurich, Switzerland195Reviewed Janu... |
| 350 | Speer20192Reviewed July 4, 2019 Ein Restaurant... |
| 351 | Tulum1999Zurich, Switzerland139Reviewed March ... |
352 rows × 1 columns
In [8]:
| text | |
|---|---|
| 0 | Melli10Zurich, Switzerland8167Reviewed October... |
| 1 | MMKKMMKK813Reviewed May 4, 2013 via mobile Run... |
| 2 | BaudimZurich, Switzerland423248Reviewed April ... |
| 3 | stephkellZurich, Switzerland258Reviewed Septem... |
| 4 | Maxime587Zurich, Switzerland17643Reviewed Janu... |
| ... | ... |
| 347 | Dorothea MZürich, Zurich, Switzerland53Reviewe... |
| 348 | just_1_classyZurich, Switzerland194131Reviewed... |
| 349 | Tauriel1989Zurich, Switzerland195Reviewed Janu... |
| 350 | Speer20192Reviewed July 4, 2019 Ein Restaurant... |
| 351 | Tulum1999Zurich, Switzerland139Reviewed March ... |
352 rows × 1 columns
In [9]:
False
In [10]:
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | Melli10Zurich, Switzerland8167 | October 14, 2014 via mobile Super BuffetGoogl... | November 30, 2014Google Translation Vielen Da... |
| 1 | MMKKMMKK813 | May 4, 2013 via mobile Rundum schönes Erlebni... | May 6, 2013Google Translation Das freut uns s... |
| 2 | BaudimZurich, Switzerland423248 | April 7, 2016 via mobile Vegi bis vegan!Googl... | April 13, 2016Google Translation Vielen Dank ... |
| 3 | stephkellZurich, Switzerland258 | September 9, 2016 Gutes RestaurantGoogle Tran... | October 17, 2016Google Translation Vielen Dan... |
| 4 | Maxime587Zurich, Switzerland17643 | January 12, 2016 via mobile Immer wieder gute... | January 25, 2016Google Translation Vielen Dan... |
| ... | ... | ... | ... |
| 347 | Dorothea MZürich, Zurich, Switzerland53 | January 20, 2014 Wenn der zucker nicht wäre..... | February 10, 2014Google Translation Liebe Dor... |
| 348 | just_1_classyZurich, Switzerland194131 | March 12, 2015 via mobile Solides, vielseitig... | April 14, 2015Google Translation Vielen Dank ... |
| 349 | Tauriel1989Zurich, Switzerland195 | January 14, 2019 via mobile Tolles EssenGoogl... | January 16, 2019 |
| 350 | Speer20192 | July 4, 2019 Ein Restaurant mit viel Aufwand ... | August 12, 2019Google Translation Besten Dank... |
| 351 | Tulum1999Zurich, Switzerland139 | March 10, 2017 via mobile Vegi für Fleischess... | May 4, 2017Google Translation Hallo Tulum Vie... |
352 rows × 3 columns
In [11]:
In [12]:
| Deutsch_Average | |
|---|---|
| 0 | shoppingqueen5Zurich, Switzerland69Reviewed Ju... |
| 1 | BadbexxVolketswil, Switzerland9661Reviewed Feb... |
| 2 | ThereseCHComo, Italy106145Reviewed August 16, ... |
| 3 | BelaR2013Zurich, Switzerland54Reviewed May 23,... |
| 4 | 300dorisdCanton of St. Gallen, Switzerland5418... |
| ... | ... |
| 1165 | PieroN937New York City, New York7567Reviewed S... |
| 1166 | Mo_KohlZurich, Switzerland4657Reviewed July 2,... |
| 1167 | FourkidChur, Switzerland5218Reviewed December ... |
| 1168 | neitschaZurich, Switzerland5621Reviewed Januar... |
| 1169 | domiundpatiZurich, Switzerland3522Reviewed Feb... |
1170 rows × 1 columns
In [13]:
| Deutsch_Average | |
|---|---|
| 0 | shoppingqueen5Zurich, Switzerland69Reviewed Ju... |
| 1 | BadbexxVolketswil, Switzerland9661Reviewed Feb... |
| 2 | ThereseCHComo, Italy106145Reviewed August 16, ... |
| 3 | BelaR2013Zurich, Switzerland54Reviewed May 23,... |
| 4 | 300dorisdCanton of St. Gallen, Switzerland5418... |
| ... | ... |
| 270 | 910yanl1713Reviewed December 26, 2015 via mobi... |
| 284 | vorn2015Bendern, Liechtenstein13358Reviewed Se... |
| 356 | domiundpatiZurich, Switzerland3522Reviewed Feb... |
| 430 | wachsmuth2014Switzerland12474Reviewed January ... |
| 516 | BaudimZurich, Switzerland423248Reviewed Octobe... |
116 rows × 1 columns
In [14]:
False
In [15]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | shoppingqueen5Zurich, Switzerland69 | July 9, 2018 Essen fantastisch - Service leid... | August 6, 2018Google Translation Liebe shoppi... |
| 1 | BadbexxVolketswil, Switzerland9661 | February 3, 2015 Gibt besseres.Google Transla... | February 19, 2015Google Translation Vielen Da... |
| 2 | ThereseCHComo, Italy106145 | August 16, 2015 UEBERTEUERTES ESSENGoogle Tra... | September 10, 2015Google Translation Grüezi T... |
| 3 | BelaR2013Zurich, Switzerland54 | May 23, 2013 Für eingefleischte VegetarierGoo... | June 5, 2013Google Translation Wenn Sie zu de... |
| 4 | 300dorisdCanton of St. Gallen, Switzerland5418 | December 19, 2014 via mobile erwartungen nich... | None |
| ... | ... | ... | ... |
| 270 | 910yanl1713 | December 26, 2015 via mobile In OrdnungGoogle... | December 27, 2015Google Translation Grüezi Ya... |
| 284 | vorn2015Bendern, Liechtenstein13358 | September 13, 2016 via mobile Edle PreiseGoog... | October 31, 2016Google Translation Besten Dan... |
| 356 | domiundpatiZurich, Switzerland3522 | February 3, 2018 via mobile Essen Top, Servic... | February 8, 2018Google Translation Lieber Dom... |
| 430 | wachsmuth2014Switzerland12474 | January 27, 2019 Restaurant für gesundes Esse... | February 4, 2019Google Translation Besten Dan... |
| 516 | BaudimZurich, Switzerland423248 | October 5, 2017 via mobile Langweiliges Buffe... | October 12, 2017Google Translation Grüezi Bau... |
116 rows × 3 columns
In [16]:
In [17]:
| Deutsch_Poor | |
|---|---|
| 0 | Schubiger13Reviewed August 17, 2016 via mobile... |
| 1 | luisb6516Zurich, Switzerland9140Reviewed Septe... |
| 2 | 324benjaminfZurich, Switzerland288Reviewed Nov... |
| 3 | Chianakla XZurich, Switzerland15Reviewed Janua... |
| 4 | jaydee hSpreitenbach, Switzerland4121Reviewed ... |
| ... | ... |
| 485 | Emmanuel7402Canton of Zurich, Switzerland1117R... |
| 486 | A Tripadvisor reviewer on FacebookReviewed Apr... |
| 487 | luisb6516Zurich, Switzerland9140Reviewed Septe... |
| 488 | _cacolynn_145Reviewed September 20, 2018 via m... |
| 489 | kehrseiteRüschlikon72Reviewed October 4, 2014 ... |
490 rows × 1 columns
In [18]:
| Deutsch_Poor | |
|---|---|
| 0 | Schubiger13Reviewed August 17, 2016 via mobile... |
| 1 | luisb6516Zurich, Switzerland9140Reviewed Septe... |
| 2 | 324benjaminfZurich, Switzerland288Reviewed Nov... |
| 3 | Chianakla XZurich, Switzerland15Reviewed Janua... |
| 4 | jaydee hSpreitenbach, Switzerland4121Reviewed ... |
| 5 | Beat SOpfikon, Switzerland917Reviewed May 31, ... |
| 6 | brigittediZug, Switzerland114Reviewed August 1... |
| 7 | _cacolynn_145Reviewed September 20, 2018 via m... |
| 8 | jostein69Zurich, Switzerland42Reviewed August ... |
| 9 | HansM1959Zurich, Switzerland378336Reviewed Dec... |
| 10 | Artemis MZurich, Switzerland1720Reviewed Janua... |
| 11 | Liliput13Zurich, Switzerland3422Reviewed May 1... |
| 12 | Daniel RBiberist, Switzerland2Reviewed April 1... |
| 13 | Res164Zurich, Switzerland307141Reviewed July 5... |
| 14 | 811ericdTurin, Italy24098Reviewed October 25, ... |
| 16 | A Tripadvisor reviewer on FacebookReviewed Apr... |
| 18 | giusigg12413Reviewed April 17, 2016 Heute war ... |
| 25 | Karin FZurich, Switzerland1513Reviewed October... |
| 26 | Marcon2744217Reviewed March 13, 2017 via mobil... |
| 27 | Severin BBaden, Switzerland156Reviewed Novembe... |
| 30 | Peter MCanton of Zurich, Switzerland55Reviewed... |
| 32 | Nicole PBrig, Switzerland1Reviewed February 23... |
| 33 | Hightower777Zurich, Switzerland7674Reviewed Au... |
| 34 | Vanda GDietikon, Schweiz58Reviewed May 21, 201... |
| 35 | sonnenschein1979Zurich, Switzerland3938Reviewe... |
| 38 | Valeria AZurich, Switzerland4024Reviewed April... |
| 41 | Millard3112Aarau, Switzerland158Reviewed Janua... |
| 43 | micimo1418Reviewed August 28, 2017 via mobile ... |
| 44 | Emmanuel7402Canton of Zurich, Switzerland1117R... |
| 45 | dani_zee_86Zurich, Switzerland4047Reviewed Feb... |
| 48 | TravelisallpassionMunich, Germany8153Reviewed ... |
| 50 | trixefix148Biel, Switzerland233Reviewed March ... |
| 52 | USJOZRapperswil, Switzerland1515Reviewed Novem... |
| 53 | Eva BSwitzerland11Reviewed October 11, 2015 Gu... |
| 55 | escopazzo_gmx_netZurich, Switzerland137Reviewe... |
| 59 | gourmetlexZurich, Switzerland1831Reviewed July... |
| 61 | _Fab_Ulous_N242Reviewed October 10, 2018 via m... |
| 65 | 870cayZurich, Switzerland4921Reviewed August 1... |
| 68 | Gregor SZurich, Switzerland4123Reviewed July 1... |
| 71 | HaschitaschiBavaria, Germany7143Reviewed April... |
| 72 | Edi1212Zurich, Switzerland9941Reviewed June 22... |
| 74 | PeterPassigattiZurich, Canada23Reviewed Septem... |
| 76 | AdriCanellaPfaeffikon, Switzerland7055Reviewed... |
| 81 | glamgsZurich, Switzerland179Reviewed August 3,... |
| 92 | kehrseiteRüschlikon72Reviewed October 4, 2014 ... |
| 100 | KnochentrockenWangen, Switzerland1423Reviewed ... |
| 103 | Golffreund41Swiss Alps, Switzerland1031Reviewe... |
| 117 | rudolfkydMuri, Switzerland12657Reviewed Novemb... |
In [19]:
False
In [20]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | Schubiger13 | August 17, 2016 via mobile Schlechter Umgang ... | August 24, 2016Google Translation Hallo Schub... |
| 1 | luisb6516Zurich, Switzerland9140 | September 18, 2018 nicht mein Ding...ist aber... | November 1, 2018Google Translation Hallo luis... |
| 2 | 324benjaminfZurich, Switzerland288 | November 26, 2015 Langsamer ServiceGoogle Tra... | December 27, 2015Google Translation Vielen Da... |
| 3 | Chianakla XZurich, Switzerland15 | January 20, 2013 Unfreundlich, arrogant, hat ... | April 27, 2013Google Translation Liebe Chiana... |
| 4 | jaydee hSpreitenbach, Switzerland4121 | January 27, 2015 Völlig überteuertes Vegi Res... | February 19, 2015Google Translation Vielen Da... |
| 5 | Beat SOpfikon, Switzerland917 | May 31, 2014 Kein FanGoogle Translation Verst... | June 14, 2014Google Translation Hallo Beat Da... |
| 6 | brigittediZug, Switzerland114 | August 12, 2020 via mobile EnttäuschendGoogle... | September 22, 2020Google Translation Liebe br... |
| 7 | _cacolynn_145 | September 20, 2018 via mobile Essbar aber nic... | September 21, 2018Google Translation Schade R... |
| 8 | jostein69Zurich, Switzerland42 | August 12, 2014 Hiltl Mythenquai ist wieder e... | September 10, 2014Google Translation Hallo jo... |
| 9 | HansM1959Zurich, Switzerland378336 | December 9, 2017 via mobile Völlig überteuert... | December 20, 2017Google Translation Lieber Ha... |
| 10 | Artemis MZurich, Switzerland1720 | January 1, 2013 Nur weil "IN" mehr bezahlen?G... | April 29, 2013Google Translation Hallo Artemi... |
| 11 | Liliput13Zurich, Switzerland3422 | May 18, 2018 via mobile Teuer. Kleine Portion... | May 25, 2018Google Translation Hallo Liliput1... |
| 12 | Daniel RBiberist, Switzerland2 | April 11, 2019 via mobile Essen Top, Service ... | April 15, 2019Google Translation Lieber Danie... |
| 13 | Res164Zurich, Switzerland307141 | July 5, 2014 Hiltl am Publicviewing in der Ma... | July 13, 2014Google Translation Hallo Res164 ... |
| 14 | 811ericdTurin, Italy24098 | October 25, 2016 Das Ende einer Liebesgeschic... | November 1, 2016Google Translation Lieber Eri... |
| 16 | A Tripadvisor reviewer on Facebook | April 2, 2008 schöne, grosse auswahl am buffe... | None |
| 18 | giusigg12413 | April 17, 2016 Heute war gewaltig der Wurm dr... | April 21, 2016Google Translation Hallo giusig... |
| 25 | Karin FZurich, Switzerland1513 | October 9, 2014 immer etwas enttäuschender...... | February 24, 2015Google Translation Liebe Kar... |
| 26 | Marcon2744217 | March 13, 2017 via mobile Zuviel verschiedene... | None |
| 27 | Severin BBaden, Switzerland156 | November 27, 2016 zu teuerGoogle Translation ... | None |
| 30 | Peter MCanton of Zurich, Switzerland55 | June 10, 2015 Leider Überbewertet.Google Tran... | June 11, 2015Google Translation Lieber Peter ... |
| 32 | Nicole PBrig, Switzerland1 | February 23, 2015 Schade...Google Translation... | February 28, 2015Google Translation Grüezi Ni... |
| 33 | Hightower777Zurich, Switzerland7674 | August 12, 2015 via mobile Kaltes überteuerte... | September 10, 2015Google Translation Grüezi H... |
| 34 | Vanda GDietikon, Schweiz58 | May 21, 2015 via mobile FrühstückGoogle Trans... | None |
| 35 | sonnenschein1979Zurich, Switzerland3938 | March 30, 2017 via mobile MassenabfertigungGo... | April 14, 2017Google Translation Lieber Sonne... |
| 38 | Valeria AZurich, Switzerland4024 | April 15, 2014 Teuer und GeschmacklosGoogle T... | April 23, 2014Google Translation Grüezi Valer... |
| 41 | Millard3112Aarau, Switzerland158 | January 5, 2019 via mobile a la carte.... nic... | January 16, 2019Google Translation Hallo Mill... |
| 43 | micimo1418 | August 28, 2017 via mobile Nachtessen mit Nac... | September 6, 2017Google Translation Liebe mic... |
| 44 | Emmanuel7402Canton of Zurich, Switzerland1117 | December 27, 2016 via mobile It's a shame Goo... | April 21, 2017Google Translation Hallo Emmanu... |
| 45 | dani_zee_86Zurich, Switzerland4047 | February 7, 2016 via mobile Feines Veggie-Ess... | February 29, 2016Google Translation Vielen Da... |
| 48 | TravelisallpassionMunich, Germany8153 | July 1, 2018 via mobile Gutes Essen bei schle... | July 4, 2018Google Translation Hallo Travelis... |
| 50 | trixefix148Biel, Switzerland233 | March 3, 2020 Unfreundliches Personal, mediok... | October 17, 2020Google Translation Liebe Trix... |
| 52 | USJOZRapperswil, Switzerland1515 | November 20, 2014 Chaotisch!Google Translatio... | December 3, 2014Google Translation Grüezi USJ... |
| 53 | Eva BSwitzerland11 | October 11, 2015 Gutes Essen, sehr unfreundli... | December 20, 2015Google Translation Liebe Eva... |
| 55 | escopazzo_gmx_netZurich, Switzerland137 | April 28, 2017 Überbewertet.. :-(Google Trans... | April 29, 2017Google Translation Hallo Alessa... |
| 59 | gourmetlexZurich, Switzerland1831 | July 31, 2016 via mobile Indisches Buffet?!Go... | August 2, 2016Google Translation Schade, dass... |
| 61 | _Fab_Ulous_N242 | October 10, 2018 via mobile Feine Küche - seh... | October 18, 2018Google Translation Lieber _Fa... |
| 65 | 870cayZurich, Switzerland4921 | August 18, 2019 via mobile Zu teuer und Zuvie... | August 19, 2019Google Translation Hallo 870ca... |
| 68 | Gregor SZurich, Switzerland4123 | July 19, 2017 Teuer und langweiligGoogle Tran... | July 21, 2017Google Translation Lieber Gregor... |
| 71 | HaschitaschiBavaria, Germany7143 | April 17, 2017 via mobile Besuch in ZürichGoo... | May 2, 2017Google Translation Danke für deine... |
| 72 | Edi1212Zurich, Switzerland9941 | June 22, 2014 Hiltl im Mythenquai eine Laienc... | June 24, 2014Google Translation Hallo Edi1212... |
| 74 | PeterPassigattiZurich, Canada23 | September 25, 2014 total überfüllt und teuerG... | November 24, 2014Google Translation Grüezi He... |
| 76 | AdriCanellaPfaeffikon, Switzerland7055 | May 1, 2016 via mobile Egal was Du isst...Goo... | May 5, 2016Google Translation Hallo Canella A... |
| 81 | glamgsZurich, Switzerland179 | August 3, 2015 Gute Küche aber teuer und viel... | August 11, 2015Google Translation Grüezi glam... |
| 92 | kehrseiteRüschlikon72 | October 4, 2014 via mobile QUALITÄTSVERLUSTGo... | None |
| 100 | KnochentrockenWangen, Switzerland1423 | December 19, 2018 via mobile Vegetarisches Es... | December 21, 2018Google Translation Lieber Kn... |
| 103 | Golffreund41Swiss Alps, Switzerland1031 | February 25, 2015 EntäuschendGoogle Translati... | April 30, 2015Google Translation Danke für Ih... |
| 117 | rudolfkydMuri, Switzerland12657 | November 16, 2014 Zu laut, zu teuer, ungemütl... | February 19, 2015Google Translation Lieber Ru... |
In [21]:
In [22]:
| Deutsch_terrible | |
|---|---|
| 0 | MilicaD177Zurich, Switzerland222Reviewed March... |
| 1 | 90jasminasBerlin, Germany84Reviewed September ... |
| 2 | annafromzurichZurich, Switzerland52Reviewed Ja... |
| 3 | ericabeelerZurich, Switzerland11Reviewed May 1... |
| 4 | ljaenner26Reviewed March 31, 2016 via mobile E... |
| ... | ... |
| 200 | anjas298798Reviewed November 7, 2016 via mobil... |
| 201 | MilicaD177Zurich, Switzerland222Reviewed March... |
| 202 | 72mizZurich, Switzerland167Reviewed January 31... |
| 203 | ericabeelerZurich, Switzerland11Reviewed May 1... |
| 204 | 90jasminasBerlin, Germany84Reviewed September ... |
205 rows × 1 columns
In [23]:
| Deutsch_terrible | |
|---|---|
| 0 | MilicaD177Zurich, Switzerland222Reviewed March... |
| 1 | 90jasminasBerlin, Germany84Reviewed September ... |
| 2 | annafromzurichZurich, Switzerland52Reviewed Ja... |
| 3 | ericabeelerZurich, Switzerland11Reviewed May 1... |
| 4 | ljaenner26Reviewed March 31, 2016 via mobile E... |
| 7 | mpatricia85Zurich, Switzerland419Reviewed Dece... |
| 8 | 8000Miriam88Baden, Switzerland3759Reviewed May... |
| 9 | Nitz55Canton of Zurich, Switzerland52132Review... |
| 10 | anjas298798Reviewed November 7, 2016 via mobil... |
| 14 | patricia_70Schweiz205154Reviewed February 11, ... |
| 15 | Sieben7723Reviewed June 6, 2013 via mobile Zu ... |
| 17 | degabriellaOberrieden, Switzerland145120Review... |
| 18 | 72mizZurich, Switzerland167Reviewed January 31... |
| 20 | raphael702016Zurich, Switzerland58Reviewed Aug... |
| 22 | FreshbackZurich, Switzerland8839Reviewed Septe... |
| 25 | No LZurich, Switzerland44Reviewed January 20, ... |
| 28 | roos68Basel, Switzerland71Reviewed March 8, 20... |
| 29 | HajnalkaMZurich, Switzerland4554Reviewed May 3... |
| 31 | ankatiZürich1421Reviewed July 9, 2020 Arrogant... |
| 38 | margaritaZHzürich512Reviewed August 26, 2013 ü... |
| 41 | SolverteamZurich, Switzerland1717Reviewed Marc... |
| 44 | vikilee5152Reviewed May 13, 2017 via mobile Im... |
| 45 | Christian GZurich, Switzerland2255Reviewed Jul... |
| 54 | Geniesser797Zurich, Switzerland6269Reviewed Ma... |
| 151 | A Tripadvisor reviewer on FacebookZurich, Swit... |
In [24]:
False
In [25]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | MilicaD177Zurich, Switzerland222 | March 15, 2016 via mobile Am liebsten jeden T... | March 17, 2016Google Translation Hallo Milica... |
| 1 | 90jasminasBerlin, Germany84 | September 10, 2017 Kochkurs im HiltlGoogle Tr... | September 13, 2017Google Translation Liebe Ja... |
| 2 | annafromzurichZurich, Switzerland52 | January 4, 2014 MassenabfertigungGoogle Trans... | February 10, 2014Google Translation Hallo ann... |
| 3 | ericabeelerZurich, Switzerland11 | May 17, 2017 Online Reservation wurde abgände... | May 29, 2017Google Translation Liebe Frau Bee... |
| 4 | ljaenner26 | March 31, 2016 via mobile EnttäuschtGoogle Tr... | April 11, 2016Google Translation Hallo ljaenn... |
| 7 | mpatricia85Zurich, Switzerland419 | December 29, 2016 Schon lange nicht mehr sooo... | April 26, 2017Google Translation Liebe Patric... |
| 8 | 8000Miriam88Baden, Switzerland3759 | May 10, 2019 via mobile Ich verstehe den Hype... | May 13, 2019Google Translation Liebe 8000Miri... |
| 9 | Nitz55Canton of Zurich, Switzerland52132 | March 13, 2016 via mobile Nie mehrGoogle Tran... | March 17, 2016Google Translation Hallo Nitz 5... |
| 10 | anjas298798 | November 7, 2016 via mobile Sehr gutes EssenG... | November 18, 2016Google Translation Besten Da... |
| 14 | patricia_70Schweiz205154 | February 11, 2016 Zu teuer - um 11.45Uhr scho... | February 29, 2016Google Translation Hallo Pat... |
| 15 | Sieben7723 | June 6, 2013 via mobile Zu laut und zu teuerG... | June 7, 2013Google Translation Diese Pauschal... |
| 17 | degabriellaOberrieden, Switzerland145120 | July 10, 2018 via mobile SonntagsbrunchGoogle... | August 23, 2018Google Translation Liebe degab... |
| 18 | 72mizZurich, Switzerland167 | January 31, 2016 via mobile Gibt besseresGoog... | February 2, 2016Google Translation Grüezi MI ... |
| 20 | raphael702016Zurich, Switzerland58 | August 2, 2016 Gastfreundlichkeit Fehlanzeige... | August 24, 2016Google Translation Lieber Raph... |
| 22 | FreshbackZurich, Switzerland8839 | September 9, 2016 via mobile Nur teuer Google... | October 18, 2016Google Translation Hallo Mich... |
| 25 | No LZurich, Switzerland44 | January 20, 2014 Viel zu teuerGoogle Translat... | February 10, 2014Google Translation Lieber Da... |
| 28 | roos68Basel, Switzerland71 | March 8, 2015 Arrogante unfreundlliche Servic... | May 12, 2015Google Translation Hallo roos68 D... |
| 29 | HajnalkaMZurich, Switzerland4554 | May 30, 2014 hektisch, voll, unverschämt teue... | June 14, 2014Google Translation Grüezi Hajnal... |
| 31 | ankatiZürich1421 | July 9, 2020 Arrogant, kompliziert, ungemütli... | July 14, 2020Google Translation Liebe ankati ... |
| 38 | margaritaZHzürich512 | August 26, 2013 üüberbewertet!Google Translat... | September 20, 2013Google Translation Hallo Ma... |
| 41 | SolverteamZurich, Switzerland1717 | March 9, 2019 via mobile Abwärtstrend Google ... | March 11, 2019Google Translation Lieber Solve... |
| 44 | vikilee5152 | May 13, 2017 via mobile Immer sehr hektisch G... | May 29, 2017Google Translation Hallo 53violaf... |
| 45 | Christian GZurich, Switzerland2255 | July 12, 2013 Essen, Zahlen, AbdüsenGoogle Tr... | July 17, 2013Google Translation Danke, dass S... |
| 54 | Geniesser797Zurich, Switzerland6269 | March 11, 2017 via mobile Arroganz pur, Essen... | April 14, 2017Google Translation Lieber Genie... |
| 151 | A Tripadvisor reviewer on FacebookZurich, Swit... | April 20, 2008 Vegetarische Fleischvögel? Sto... | None |
In [26]:
Reviews Englisch
In [27]:
| text | |
|---|---|
| 0 | SwisslimosKloten, Schweiz33Bewertet am 29. Jun... |
| 1 | David HZürich, Schweiz8345Bewertet am 7. April... |
| 2 | BobBoghosLangnau am Albis, Schweiz9265Bewertet... |
| 3 | pswamy99Washington, D.C., District of Columbia... |
| 4 | ZimtsternZürich, Schweiz5243Bewertet am 29. Se... |
| ... | ... |
| 202 | janhal01Zürich, Schweiz64Bewertet am 4. Novemb... |
| 203 | marcs775142Bewertet am 10. Januar 2015 no good... |
| 204 | 4antoninaZürich, Schweiz33Bewertet am 9. Septe... |
| 205 | marcs775142Bewertet am 10. Januar 2015 no good... |
| 206 | David HZürich, Schweiz8345Bewertet am 7. April... |
207 rows × 1 columns
In [28]:
| text | |
|---|---|
| 0 | SwisslimosKloten, Schweiz33Bewertet am 29. Jun... |
| 1 | David HZürich, Schweiz8345Bewertet am 7. April... |
| 2 | BobBoghosLangnau am Albis, Schweiz9265Bewertet... |
| 3 | pswamy99Washington, D.C., District of Columbia... |
| 4 | ZimtsternZürich, Schweiz5243Bewertet am 29. Se... |
| 5 | Lucy-travel-diaryGenf, Schweiz1419Bewertet am ... |
| 7 | W7da1Bewertet am 30. Juli 2016 über Mobile-App... |
| 9 | eikitukiDos Hermanas, Spanien137Bewertet am 2.... |
| 10 | marclP6434EC33Bewertet am 4. August 2019 über ... |
| 11 | paolakarinaswitzerland2929Bewertet am 3. Dezem... |
| 16 | Destination2015Europa5660Bewertet am 18. Novem... |
| 17 | luzurichzurich627Bewertet am 10. Juli 2009 not... |
| 22 | marcs775142Bewertet am 10. Januar 2015 no good... |
| 23 | 90paulid236Bewertet am 22. Oktober 2019 They d... |
| 28 | 859aakashd77Bewertet am 22. Dezember 2018 über... |
| 29 | Carlo_Milan_ItalyItalien267139Bewertet am 22. ... |
| 32 | 4antoninaZürich, Schweiz33Bewertet am 9. Septe... |
| 33 | janhal01Zürich, Schweiz64Bewertet am 4. Novemb... |
| 39 | ZarzillaPrag, Tschechien267Bewertet am 7. Nove... |
| 40 | trap84Zürich, Schweiz66111Bewertet am 27. Mai ... |
| 47 | JohnDMasonStoke-on-Trent, Vereinigtes Königrei... |
| 55 | Taran9000Zürich, Schweiz1Bewertet am 3. Januar... |
| 91 | Ein Tripadvisor-Bewerter auf FacebookBewertet ... |
| 102 | DizzyTravelGenf, Schweiz11471Bewertet am 23. F... |
| 104 | Ein Tripadvisor-Bewerter auf FacebookBewertet ... |
| 143 | itzibitzizurich391319Bewertet am 6. April 2013... |
| 199 | Sabinne_laheZürich, Schweiz13Bewertet am 31. O... |
In [29]:
False
In [30]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | SwisslimosKloten, Schweiz33 | 29. Juni 2019 über Mobile-Apps Expensive Mit ... | 3. Juli 2019Mit Google übersetzen Dear Swissl... |
| 1 | David HZürich, Schweiz8345 | 7. April 2016 The most over-rated restaurant ... | 13. April 2016Mit Google übersetzen Dear Ping... |
| 2 | BobBoghosLangnau am Albis, Schweiz9265 | 1. Juni 2018 über Mobile-Apps Prison Food for... | 14. Juni 2018Mit Google übersetzen Dear Bob B... |
| 3 | pswamy99Washington, D.C., District of Columbia2 | 30. Juni 2017 über Mobile-Apps Ridiculous, No... | 1. Juli 2017Mit Google übersetzen Dear Pradee... |
| 4 | ZimtsternZürich, Schweiz5243 | 29. September 2020 Sub-optimal COVID precauti... | 16. Oktober 2020Mit Google übersetzen Dear Zi... |
| 5 | Lucy-travel-diaryGenf, Schweiz1419 | 5. Januar 2019 über Mobile-Apps Good food ter... | 16. Januar 2019Mit Google übersetzen Hey Lucy... |
| 7 | W7da1 | 30. Juli 2016 über Mobile-Apps It's either th... | 24. August 2016Mit Google übersetzen Dear W7d... |
| 9 | eikitukiDos Hermanas, Spanien137 | 2. August 2015 über Mobile-Apps Bad serviceTh... | 12. August 2015Mit Google übersetzen Dear eik... |
| 10 | marclP6434EC33 | 4. August 2019 über Mobile-Apps Nightclub tre... | 12. August 2019Mit Google übersetzen Dear mar... |
| 11 | paolakarinaswitzerland2929 | 3. Dezember 2014 Worst service everIt s quite... | 16. Februar 2015Mit Google übersetzen Dear pa... |
| 16 | Destination2015Europa5660 | 18. November 2015 Lousy service and just a ea... | 22. Dezember 2015Mit Google übersetzen We are... |
| 17 | luzurichzurich627 | 10. Juli 2009 not that good!Mit Google überse... | None |
| 22 | marcs775142 | 10. Januar 2015 no good choiceMit Google über... | 11. Mai 2015Mit Google übersetzen We are very... |
| 23 | 90paulid236 | 22. Oktober 2019 They do not listenMit Google... | 28. Oktober 2019Mit Google übersetzen Dear 90... |
| 28 | 859aakashd77 | 22. Dezember 2018 über Mobile-Apps All that G... | 28. Dezember 2018Mit Google übersetzen Dear 8... |
| 29 | Carlo_Milan_ItalyItalien267139 | 22. März 2017 So disappointing.This is the ol... | 14. April 2017Mit Google übersetzen Dear Carl... |
| 32 | 4antoninaZürich, Schweiz33 | 9. September 2017 über Mobile-Apps Disastrous... | 13. September 2017Mit Google übersetzen Dear ... |
| 33 | janhal01Zürich, Schweiz64 | 4. November 2014 Stay away!Hiltl is an instit... | 16. Februar 2015Mit Google übersetzen Dear Ja... |
| 39 | ZarzillaPrag, Tschechien267 | 7. November 2014 Poor service, expensive for ... | 12. Mai 2015Mit Google übersetzen We are very... |
| 40 | trap84Zürich, Schweiz66111 | 27. Mai 2017 über Mobile-Apps Terribile food ... | 29. Mai 2017Mit Google übersetzen Dear Trap84... |
| 47 | JohnDMasonStoke-on-Trent, Vereinigtes Königrei... | 23. Februar 2018 No Table/No fun/No ServiceMi... | 8. März 2018Mit Google übersetzen Dear JohnDM... |
| 55 | Taran9000Zürich, Schweiz1 | 3. Januar 2009 Overpriced vegetarian food, sm... | None |
| 91 | Ein Tripadvisor-Bewerter auf Facebook | 27. Dezember 2008 pretentious and oppressive,... | None |
| 102 | DizzyTravelGenf, Schweiz11471 | 23. Februar 2012 Too ExpensiveMit Google über... | None |
| 104 | Ein Tripadvisor-Bewerter auf Facebook | 26. November 2007 If you wana pay a lot a...M... | None |
| 143 | itzibitzizurich391319 | 6. April 2013 what a flop!!!Mit Google überse... | 23. April 2013Mit Google übersetzen Hello itz... |
| 199 | Sabinne_laheZürich, Schweiz13 | 31. Oktober 2011 ITS RIDICULOUSLY EXPENSIVE (... | 14. April 2016Mit Google übersetzen We are ve... |
In [31]:
In [32]:
| text | |
|---|---|
| 0 | Elaine CTauranga, Neuseeland4723Bewertet am 27... |
| 1 | MonacoNewmarkDubai, UAE1517Bewertet am 23. Okt... |
| 2 | AsakatrinZürich, Schweiz5229Bewertet am 12. Mä... |
| 3 | HolidayProFra90Zürich, Schweiz2Bewertet am 28.... |
| 4 | bubotravelUetikon am See, Schweiz4534Bewertet ... |
| ... | ... |
| 404 | Emmanuel7402Kanton Zürich, Schweiz1117Bewertet... |
| 405 | K3741IDmichaeldRochester, New York1Bewertet am... |
| 406 | Parides7Zürich, Schweiz248Bewertet am 23. Augu... |
| 407 | IrinchenZurich, Switzerland1110Bewertet am 13.... |
| 408 | DGandSAGSharon, MA367329Bewertet am 17. Septem... |
409 rows × 1 columns
In [33]:
| text | |
|---|---|
| 0 | Elaine CTauranga, Neuseeland4723Bewertet am 27... |
| 1 | MonacoNewmarkDubai, UAE1517Bewertet am 23. Okt... |
| 2 | AsakatrinZürich, Schweiz5229Bewertet am 12. Mä... |
| 3 | HolidayProFra90Zürich, Schweiz2Bewertet am 28.... |
| 4 | bubotravelUetikon am See, Schweiz4534Bewertet ... |
| 5 | Titiana2Tel Aviv, Israel3118Bewertet am 11. Au... |
| 6 | Pickle4355Dallas, Texas6539Bewertet am 27. Aug... |
| 9 | Aarthi GSunnyvale, Kalifornien157Bewertet am 6... |
| 11 | AndreaLedermannOberthal, Schweiz5128Bewertet a... |
| 12 | tIGN1Zürich, Schweiz13534Bewertet am 4. März 2... |
| 13 | Tenzin513Zürich, Schweiz1310Bewertet am 18. Mä... |
| 14 | DGandSAGSharon, MA367329Bewertet am 17. Septem... |
| 16 | LeDaveZürich, Schweiz5038Bewertet am 7. März 2... |
| 17 | Elise GZurich131Bewertet am 19. September 2012... |
| 18 | koljaR1971Zürich, Schweiz3225Bewertet am 19. F... |
| 19 | Gary BTel Aviv, Israel225151Bewertet am 13. Au... |
| 21 | authumbla86Zürich, Schweiz1215Bewertet am 14. ... |
| 22 | Parides7Zürich, Schweiz248Bewertet am 23. Augu... |
| 23 | Sybe THaarlem, Niederlande175Bewertet am 29. J... |
| 24 | AlbertoMayRancho Santa Fe, Kalifornien856404Be... |
| 25 | mariamH1275LGUitikon, Schweiz4310Bewertet am 2... |
| 26 | René AZürich, Schweiz606264Bewertet am 30. Sep... |
| 27 | Анастасия КZürich, Schweiz2231Bewertet am 5. D... |
| 28 | SOHT7711542Bewertet am 25. November 2017 über ... |
| 32 | depu612016Kanton Zürich, Schweiz31Bewertet am ... |
| 33 | poruskyLausanne, Schweiz6246Bewertet am 9. Sep... |
| 34 | Fun123456789London, Vereinigtes Königreich3Bew... |
| 39 | jjgodOslo, Norwegen42Bewertet am 26. Oktober 2... |
| 40 | kedarvashiMumbai (Bombay), Indien3624Bewertet ... |
| 41 | SophiegirLondon, Vereinigtes Königreich124355B... |
| 51 | Ronald KZürich, Schweiz2225Bewertet am 18. Feb... |
| 52 | IrinchenZurich, Switzerland1110Bewertet am 13.... |
| 54 | Ein Tripadvisor-Bewerter auf FacebookBewertet ... |
| 57 | Auro ACH2311Bewertet am 23. Januar 2016 Tastel... |
| 60 | d50kimoCorinth, Texas6257Bewertet am 21. Janua... |
| 72 | Ein Tripadvisor-Bewerter auf FacebookSydney, A... |
| 73 | Tedwong1977Zürich, Schweiz6071Bewertet am 28. ... |
| 84 | K3741IDmichaeldRochester, New York1Bewertet am... |
| 85 | James HAarau, Schweiz9345Bewertet am 27. Mai 2... |
| 90 | patpatel120London, Vereinigtes Königreich97Bew... |
| 94 | CharlonpZürich, Schweiz1417Bewertet am 7. Augu... |
| 95 | hephaistionchKitzbühel, Österreich5843Bewertet... |
| 104 | Ein Tripadvisor-Bewerter auf FacebookKüsnacht,... |
| 105 | Krzysztof GBrüssel, Belgien11197Bewertet am 28... |
| 131 | Emmanuel7402Kanton Zürich, Schweiz1117Bewertet... |
| 223 | driver75St. Moritz, Schweiz5031Bewertet am 18.... |
| 255 | Ein Tripadvisor-Bewerter auf FacebookBewertet ... |
| 305 | SarahB BZürich, Schweiz94Bewertet am 10. Septe... |
| 331 | DanB998Niagara Falls, New York4474Bewertet am ... |
In [34]:
False
In [35]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | Elaine CTauranga, Neuseeland4723 | 27. August 2017 GREAT FOOD BUT WEREN'T TOLD A... | 4. September 2017Mit Google übersetzen Dear A... |
| 1 | MonacoNewmarkDubai, UAE1517 | 23. Oktober 2018 über Mobile-Apps Wasn’t impr... | 29. Oktober 2018Mit Google übersetzen Dear Mo... |
| 2 | AsakatrinZürich, Schweiz5229 | 12. März 2014 Not that greatIndian veggie.. I... | 26. März 2014Mit Google übersetzen Dear Asaka... |
| 3 | HolidayProFra90Zürich, Schweiz2 | 28. November 2016 über Mobile-Apps A fancy ca... | 20. Dezember 2016Mit Google übersetzen Dear H... |
| 4 | bubotravelUetikon am See, Schweiz4534 | 3. Januar 2019 über Mobile-Apps OverratedMit ... | 16. Januar 2019Mit Google übersetzen Hey bubo... |
| 5 | Titiana2Tel Aviv, Israel3118 | 11. August 2016 Dirty dishes and a bad attitu... | 1. November 2016Mit Google übersetzen Dear Ti... |
| 6 | Pickle4355Dallas, Texas6539 | 27. August 2018 Expensive Indian BuffetMit Go... | 4. September 2018Mit Google übersetzen Dear P... |
| 9 | Aarthi GSunnyvale, Kalifornien157 | 6. Februar 2020 Mediocre food. Too crowded.Mi... | 17. Oktober 2020Mit Google übersetzen Dear Aa... |
| 11 | AndreaLedermannOberthal, Schweiz5128 | 24. März 2015 über Mobile-Apps Food is averag... | None |
| 12 | tIGN1Zürich, Schweiz13534 | 4. März 2018 Low quality of food - all the re... | 8. März 2018Mit Google übersetzen Dear Tania ... |
| 13 | Tenzin513Zürich, Schweiz1310 | 18. März 2018 Good food, silly and loud music... | 1. April 2018Mit Google übersetzen Dear Tenzi... |
| 14 | DGandSAGSharon, MA367329 | 17. September 2015 Has Gone DownhillMit Googl... | 17. März 2016Mit Google übersetzen Dear DGand... |
| 16 | LeDaveZürich, Schweiz5038 | 7. März 2015 Overrated and hipster-crowdedOk,... | 12. Mai 2015Mit Google übersetzen Dear LeDave... |
| 17 | Elise GZurich131 | 19. September 2012 Good for vegeteriansQuite ... | None |
| 18 | koljaR1971Zürich, Schweiz3225 | 19. Februar 2017 über Mobile-Apps A hype plac... | 14. April 2017Mit Google übersetzen Dear Kolj... |
| 19 | Gary BTel Aviv, Israel225151 | 13. August 2013 What's all the fuss about?Thi... | 29. August 2013Mit Google übersetzen Dear Poi... |
| 21 | authumbla86Zürich, Schweiz1215 | 14. November 2014 Expensive & crowded (and ob... | 16. Februar 2015Mit Google übersetzen Thank y... |
| 22 | Parides7Zürich, Schweiz248 | 23. August 2015 über Mobile-Apps Bad ServiceW... | 27. August 2015Mit Google übersetzen Dear Par... |
| 23 | Sybe THaarlem, Niederlande175 | 29. Juli 2020 disappointing qualityMit Google... | 3. August 2020Mit Google übersetzen Dear Sybe... |
| 24 | AlbertoMayRancho Santa Fe, Kalifornien856404 | 8. Juli 2017 Average fast food.They just thro... | 10. Juli 2017Mit Google übersetzen Dear Alber... |
| 25 | mariamH1275LGUitikon, Schweiz4310 | 21. April 2017 Your Classic Vegi in ZurichMit... | 27. April 2017Mit Google übersetzen Dear Mari... |
| 26 | René AZürich, Schweiz606264 | 30. September 2014 Over priced and too trendy... | 29. Dezember 2014Mit Google übersetzen Dear r... |
| 27 | Анастасия КZürich, Schweiz2231 | 5. Dezember 2014 Only for vegeterians!We went... | 26. Januar 2015Mit Google übersetzen Thank yo... |
| 28 | SOHT7711542 | 25. November 2017 über Mobile-Apps Over price... | None |
| 32 | depu612016Kanton Zürich, Schweiz31 | 3. März 2016 Not really what you pay forQuali... | 17. März 2016Mit Google übersetzen Dear depu6... |
| 33 | poruskyLausanne, Schweiz6246 | 9. September 2019 über Mobile-Apps What a pri... | 16. September 2019Mit Google übersetzen Dear ... |
| 34 | Fun123456789London, Vereinigtes Königreich3 | 15. Juni 2013 vegeterian foodSelf service veg... | 20. Juni 2013Mit Google übersetzen We are not... |
| 39 | jjgodOslo, Norwegen42 | 26. Oktober 2014 Not worth itMit Google übers... | 16. Februar 2015Mit Google übersetzen Dear Ji... |
| 40 | kedarvashiMumbai (Bombay), Indien3624 | 20. Juli 2015 Ruined experience by a rude sta... | 10. August 2015Mit Google übersetzen Dear ked... |
| 41 | SophiegirLondon, Vereinigtes Königreich124355 | 8. Juni 2017 You steal my moneyI am not used ... | 12. Juni 2017Mit Google übersetzen Dear Sophi... |
| 51 | Ronald KZürich, Schweiz2225 | 18. Februar 2015 Highly over-rated and over-p... | 12. Mai 2015Mit Google übersetzen I am very s... |
| 52 | IrinchenZurich, Switzerland1110 | 13. April 2014 Not my favourite place for sur... | 30. April 2014Mit Google übersetzen Dear Irin... |
| 54 | Ein Tripadvisor-Bewerter auf Facebook | 20. Dezember 2007 Oldest Swiss vegetarian...M... | None |
| 57 | Auro ACH2311 | 23. Januar 2016 Tasteless, low quality, overp... | 17. März 2016Mit Google übersetzen Hi Auro A ... |
| 60 | d50kimoCorinth, Texas6257 | 21. Januar 2013 did not live up to expectatio... | 29. April 2013Mit Google übersetzen Hi d50kim... |
| 72 | Ein Tripadvisor-Bewerter auf FacebookSydney, A... | 27. Dezember 2008 very expensive and packed -... | None |
| 73 | Tedwong1977Zürich, Schweiz6071 | 28. September 2016 über Mobile-Apps Ordinary ... | 31. Oktober 2016Mit Google übersetzen Thank y... |
| 84 | K3741IDmichaeldRochester, New York1 | 31. Juli 2018 über Mobile-Apps 100 minutes Mi... | 4. September 2018Mit Google übersetzen Dear M... |
| 85 | James HAarau, Schweiz9345 | 27. Mai 2016 Luke warm, overpricedThis place ... | 7. Juni 2016Mit Google übersetzen Dear Hochre... |
| 90 | patpatel120London, Vereinigtes Königreich97 | 30. August 2015 über Mobile-Apps Overated veg... | 22. Dezember 2015Mit Google übersetzen Thank ... |
| 94 | CharlonpZürich, Schweiz1417 | 7. August 2011 Overrated, terrible service.Mi... | None |
| 95 | hephaistionchKitzbühel, Österreich5843 | 25. Februar 2013 crowded and expensiveMit Goo... | 19. März 2013Mit Google übersetzen Come on! |
| 104 | Ein Tripadvisor-Bewerter auf FacebookKüsnacht,... | 4. Juni 2008 Is ok for a lunch break...Mit Go... | None |
| 105 | Krzysztof GBrüssel, Belgien11197 | 28. Juli 2013 A mistakeWe went to Hiltl very ... | 2. August 2013Mit Google übersetzen Dear Krzy... |
| 131 | Emmanuel7402Kanton Zürich, Schweiz1117 | 28. Dezember 2019 It's really shamefullMit Go... | 3. Januar 2020Mit Google übersetzen Dear Emma... |
| 223 | driver75St. Moritz, Schweiz5031 | 18. August 2012 Nice food but seriously overp... | 22. August 2012Mit Google übersetzen Dear dri... |
| 255 | Ein Tripadvisor-Bewerter auf Facebook | 25. Juni 2008 Nothing special. Heavy traffic ... | None |
| 305 | SarahB BZürich, Schweiz94 | 10. September 2012 Good food but not the best... | 2. April 2016Mit Google übersetzen Thank you ... |
| 331 | DanB998Niagara Falls, New York4474 | 4. Oktober 2012 Not what is used to beMit Goo... | 14. April 2016Mit Google übersetzen We are ve... |
In [36]:
In [37]:
| text | |
|---|---|
| 0 | Isabella MZürich, Schweiz4337Bewertet am 9. Fe... |
| 1 | SanmassiZürich, Schweiz2310Bewertet am 21. Jun... |
| 2 | 681prashantgKanpur, Indien183Bewertet am 29. S... |
| 3 | tashi_p188113Zürich, Schweiz185Bewertet am 11.... |
| 4 | Ewan COxford, Vereinigtes Königreich77Bewertet... |
| ... | ... |
| 1587 | schakarovaSofia103Bewertet am 6. Oktober 2015 ... |
| 1588 | Zugersee53Nikosia, Zypern14234Bewertet am 12. ... |
| 1589 | jtizorinNew York City, New York7328Bewertet am... |
| 1590 | 712asZürich, Schweiz203Bewertet am 26. August ... |
| 1591 | ZuriGuschtiWettswil, Schweiz218112Bewertet am ... |
1592 rows × 1 columns
In [38]:
| text | |
|---|---|
| 0 | Isabella MZürich, Schweiz4337Bewertet am 9. Fe... |
| 1 | SanmassiZürich, Schweiz2310Bewertet am 21. Jun... |
| 2 | 681prashantgKanpur, Indien183Bewertet am 29. S... |
| 3 | tashi_p188113Zürich, Schweiz185Bewertet am 11.... |
| 4 | Ewan COxford, Vereinigtes Königreich77Bewertet... |
| ... | ... |
| 516 | madhujain2015Neu-Delhi, Indien2328Bewertet am ... |
| 532 | l-globetrotterLondon, Vereinigtes Königreich77... |
| 559 | constantinap492Zürich, Schweiz6227Bewertet am ... |
| 565 | YG1978Tel Aviv, Israel17482Bewertet am 12. Sep... |
| 1444 | Ein Tripadvisor-Bewerter auf FacebookFribourg,... |
162 rows × 1 columns
In [39]:
False
In [40]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | Isabella MZürich, Schweiz4337 | 9. Februar 2016 Very tasty food BUT TOO LOUD ... | 4. März 2016Mit Google übersetzen Thank you f... |
| 1 | SanmassiZürich, Schweiz2310 | 21. Juni 2015 Incredible varieties and tastes... | 22. Juni 2015Mit Google übersetzen We are ver... |
| 2 | 681prashantgKanpur, Indien183 | 29. September 2019 über Mobile-Apps Disappoin... | 2. Oktober 2019Mit Google übersetzen Dear 681... |
| 3 | tashi_p188113Zürich, Schweiz185 | 11. März 2014 Used to be betterMit Google übe... | 26. März 2014Mit Google übersetzen Dear tashi... |
| 4 | Ewan COxford, Vereinigtes Königreich77 | 2. Mai 2015 Great vegetarian food, inconsiste... | 8. Mai 2015Mit Google übersetzen Dear Ewan C.... |
| ... | ... | ... | ... |
| 516 | madhujain2015Neu-Delhi, Indien2328 | 26. Juni 2015 an average,overated restaurant!... | 8. Juli 2015Mit Google übersetzen Dear madhuj... |
| 532 | l-globetrotterLondon, Vereinigtes Königreich77... | 24. November 2012 Just Ok, but expensive if y... | 23. März 2016Mit Google übersetzen We are sor... |
| 559 | constantinap492Zürich, Schweiz6227 | 12. April 2015 Vegetarian basics, lack of cre... | 7. Mai 2015Mit Google übersetzen Thank you fo... |
| 565 | YG1978Tel Aviv, Israel17482 | 12. September 2012 Very popular, nice setting... | 18. September 2012Mit Google übersetzen Thx f... |
| 1444 | Ein Tripadvisor-Bewerter auf FacebookFribourg,... | 30. Dezember 2007 Very good vegetarian food, ... | None |
162 rows × 3 columns
In [41]:
In [42]:
| text | |
|---|---|
| 0 | 0121kamzurich2616Bewertet am 10. Juli 2012 Gre... |
| 1 | Acacio88Zürich, Schweiz1718Bewertet am 3. Juni... |
| 2 | K GHammond, Indiana6319Bewertet am 7. Septembe... |
| 3 | Debbie KJerusalem, Israel177120Bewertet am 28.... |
| 4 | LindaLLAllentown, Pennsylvania4131Bewertet am ... |
| ... | ... |
| 6395 | lowelevelLondon, Vereinigtes Königreich3611Bew... |
| 6396 | BJRAM99Singapur, Singapur3510Bewertet am 28. D... |
| 6397 | DaKe72Zürich, Schweiz503160Bewertet am 10. Mai... |
| 6398 | mrsp188113Zürich, Schweiz8933Bewertet am 12. M... |
| 6399 | dragontail129Farragut, Tennessee263Bewertet am... |
6400 rows × 1 columns
In [43]:
| text | |
|---|---|
| 0 | 0121kamzurich2616Bewertet am 10. Juli 2012 Gre... |
| 1 | Acacio88Zürich, Schweiz1718Bewertet am 3. Juni... |
| 2 | K GHammond, Indiana6319Bewertet am 7. Septembe... |
| 3 | Debbie KJerusalem, Israel177120Bewertet am 28.... |
| 4 | LindaLLAllentown, Pennsylvania4131Bewertet am ... |
| ... | ... |
| 3115 | Ast838Zürich, Schweiz11350Bewertet am 19. Nove... |
| 4403 | yumakimidoriMetz, Frankreich5Bewertet am 17. J... |
| 6084 | ClaudiaK27Hollywood, Florida143Bewertet am 10.... |
| 6117 | Pia MSan Diego, Kalifornien7450Bewertet am 14.... |
| 6269 | emsmrsZürich, Schweiz4031Bewertet am 30. Juni ... |
666 rows × 1 columns
In [44]:
False
In [45]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | 0121kamzurich2616 | 10. Juli 2012 Great desert buffetChocolate mo... | 14. April 2016Mit Google übersetzen Thank you... |
| 1 | Acacio88Zürich, Schweiz1718 | 3. Juni 2015 über Mobile-Apps Consistent qual... | 5. Juni 2015Mit Google übersetzen Thank you v... |
| 2 | K GHammond, Indiana6319 | 7. September 2019 Very Good Vegetarian FoodMi... | 16. September 2019Mit Google übersetzen |
| 3 | Debbie KJerusalem, Israel177120 | 28. Mai 2014 One of the best vegetarian resta... | 8. Juni 2014Mit Google übersetzen Hi Debbie T... |
| 4 | LindaLLAllentown, Pennsylvania4131 | 24. September 2016 über Mobile-Apps Buffet lu... | 14. Oktober 2016Mit Google übersetzen Thank y... |
| ... | ... | ... | ... |
| 3115 | Ast838Zürich, Schweiz11350 | 19. November 2014 Vegetarian isn't boring!Thi... | 5. Januar 2015Mit Google übersetzen Thank you... |
| 4403 | yumakimidoriMetz, Frankreich5 | 17. Juli 2019 über Mobile-Apps Interesting Mi... | 12. August 2019Mit Google übersetzen Dear hou... |
| 6084 | ClaudiaK27Hollywood, Florida143 | 10. August 2015 über Mobile-Apps Great vegeta... | 11. August 2015Mit Google übersetzen Thank yo... |
| 6117 | Pia MSan Diego, Kalifornien7450 | 14. Juli 2014 Vegetarian HeavenThis restauran... | 21. Juli 2014Mit Google übersetzen We are ver... |
| 6269 | emsmrsZürich, Schweiz4031 | 30. Juni 2015 Pretty goodHiltl is a huge rest... | 7. Juli 2015Mit Google übersetzen Dear Emsmrs... |
666 rows × 3 columns
In [46]:
In [47]:
| text | |
|---|---|
| 0 | sunil vGreenlane, Neuseeland8060Bewertet am 22... |
| 1 | kaijinjaBasel, Schweiz204Bewertet am 14. März ... |
| 2 | BobbyLuvs2TravelFremont, Kalifornien4551Bewert... |
| 3 | edcayeMadrid, Spanien2012Bewertet am 24. April... |
| 4 | BenRoelantsPuurs, Belgien2317Bewertet am 25. A... |
| ... | ... |
| 11545 | ChocoTeaNYC2913Bewertet am 1. Juli 2012 Great ... |
| 11546 | keoleoleoWatertown, Massachusetts9431Bewertet ... |
| 11547 | Hmk198310367Bewertet am 5. Juni 2017 über Mobi... |
| 11548 | Ciko12351Bewertet am 28. Juli 2019 über Mobile... |
| 11549 | mbracic192Zagreb6Bewertet am 25. Februar 2018 ... |
11550 rows × 1 columns
In [48]:
| text | |
|---|---|
| 0 | sunil vGreenlane, Neuseeland8060Bewertet am 22... |
| 1 | kaijinjaBasel, Schweiz204Bewertet am 14. März ... |
| 2 | BobbyLuvs2TravelFremont, Kalifornien4551Bewert... |
| 3 | edcayeMadrid, Spanien2012Bewertet am 24. April... |
| 4 | BenRoelantsPuurs, Belgien2317Bewertet am 25. A... |
| ... | ... |
| 6128 | Julia TZürich, Schweiz24Bewertet am 2. Juni 20... |
| 7668 | melissaggh41Bewertet am 2. Juni 2019 über Mobi... |
| 9640 | 89thstNew York City, New York434126Bewertet am... |
| 10565 | CeK1305Kanton Zürich, Schweiz104Bewertet am 19... |
| 10652 | applee17London, Vereinigtes Königreich387Bewer... |
1167 rows × 1 columns
In [49]:
False
In [50]:
/usr/local/lib/python3.8/dist-packages/pandas/core/frame.py:3191: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
self[k1] = value[k2]
| Name | Review Gast | Response Hiltl | |
|---|---|---|---|
| 0 | sunil vGreenlane, Neuseeland8060 | 22. August 2016 Best vegetarian buffetWow! th... | 24. August 2016Mit Google übersetzen Thank yo... |
| 1 | kaijinjaBasel, Schweiz204 | 14. März 2016 Excellent food for vegetariansE... | 15. März 2016Mit Google übersetzen Thank you ... |
| 2 | BobbyLuvs2TravelFremont, Kalifornien4551 | 10. Dezember 2018 über Mobile-Apps Best veget... | 18. Dezember 2018Mit Google übersetzen Wow - ... |
| 3 | edcayeMadrid, Spanien2012 | 24. April 2016 über Mobile-Apps FantasticThis... | 25. April 2016Mit Google übersetzen Dear edca... |
| 4 | BenRoelantsPuurs, Belgien2317 | 25. August 2014 über Mobile-Apps World classW... | None |
| ... | ... | ... | ... |
| 6128 | Julia TZürich, Schweiz24 | 2. Juni 2014 Really good restaurantOnce you a... | 8. Juni 2014Mit Google übersetzen Fabulous fe... |
| 7668 | melissaggh41 | 2. Juni 2019 über Mobile-Apps UnexpectedMit G... | 3. Juni 2019Mit Google übersetzen 💚 |
| 9640 | 89thstNew York City, New York434126 | 27. Mai 2019 Well worth eating hereMit Google... | 28. Mai 2019Mit Google übersetzen 💚 |
| 10565 | CeK1305Kanton Zürich, Schweiz104 | 19. Juni 2019 Thank God!Mit Google übersetzen... | 3. Juli 2019Mit Google übersetzen 💚 |
| 10652 | applee17London, Vereinigtes Königreich387 | 26. Mai 2019 Great choice of vegetarian foodM... | 28. Mai 2019Mit Google übersetzen 💚 |
1167 rows × 3 columns
In [51]: