title: Read .txt files containing hotel reviews into data frames while keeping integrity of hotel id
body: <p>I have read in a file containing several .txt files that have reviews for hotels. The file structure looks as such: <code>data&gt;beijing&gt;china_beijing_aloft_beijing_haidian, china_beijing_ascott_beijing... country_city_hotelname...n</code></p>
  <p>Each text file is structured as such:</p>
  <pre><code>Oct 12 2009     Nice trendy hotel location not too bad. I stayed in this hotel for one night. As this is a fairly new place some of the taxi drivers did not know where it was and/or did not want to drive there. Once I have eventually arrived at the hotel, I was very pleasantly surprised with the decor of the lobby/ground floor area. It was very stylish and modern. I found the reception's staff geeting me with 'Aloha' a bit out of place, but I guess they are briefed to say that to keep up the coroporate image.As I have a Starwood Preferred Guest member, I was given a small gift upon-check in. It was only a couple of fridge magnets in a gift box, but nevertheless a nice gesture.My room was nice and roomy, there are tea and coffee facilities in each room and you get two complimentary bottles of water plus some toiletries by 'bliss'.The location is not great. It is at the last metro stop and you then need to take a taxi, but if you are not planning on going to see the historic sites in Beijing, then you will be ok.I chose to have some breakfast in the hotel, which was really tasty and there was a good selection of dishes. There are a couple of computers to use in the communal area, as well as a pool table. There is also a small swimming pool and a gym area.I would definitely stay in this hotel again, but only if I did not plan to travel to central Beijing, as it can take a long time. The location is ok if you plan to do a lot of shopping, as there is a big shopping centre just few minutes away from the hotel and there are plenty of eating options around, including restaurants that serve a dog meat!   
  Sep 25 2009     Great Budget Hotel! Stayed two nights at Aloft on the most recent trip to China. The hotel was very modern and clean. The room was spotless and a comfortable king sized bed (as far as soft beds go in China). The staff was very punctual and went out of the way to help my every need, including going to a store across the street to purchase a China Mobile SIM card for me. The buffet breakfast was okay, nothing to write home about. The 42” LCD screen had movies on demand for 20RMB and had a good selection of western channels including HBO, CNN, BBC, Star World etc… The gym was small, had a selection of basic weights and one cable machine, there was however 6 new TechnoGym cardio machines with built in LCD TVs which were very good. The location is a bit out of the way to the central areas of Beijing, but it is better suited for my needs as I need to be in the Haidian district. Being SPG Platinum there were no upgrades to a better room, because Aloft has a policy of not doing any upgrades. The Sheraton next door is a much nicer hotel in my opinion (where I am writing this from now, with an upgraded room) but as far as bang for the buck, Aloft is a great place!    
  Aug 4 2009  Excellent value - location not a big problem.   We stayed at the Aloft Beijing Haidian for 5 nights from July 17 - 22nd. There are lots of reviews that talk about the location being a problem but we knew this ahead of time and found that it really wasn't an issue. The longest we spent in a taxi was about 30 minutes. We never paid more than 50rmb for a taxi ride (which is about $8 Cdn) and that was to the Forbidden City. Given there are 4 in our family, it was no big deal at all.As for the rooms, they were clean, the beds comfortable, the wireless internet connection reliable and it was one of the few hotels we found in Beijing that would accomodate 2 adults and 2 children. We paid about $70 Cdn. per night. That's an amazing price.It's not meant to be a 5 star hotel so you can't go in expecting that. We found the reception staff generally very helpful and friendly. They aren't the fastest in the world but it wasn't unreasonable at all.The hotel manager made an effort to speak with us a few times and was extremely helpful and welcoming. Their breakfast buffet was quite good and reasonably priced. There are a number of good restaurants in the Four Points Sheraton next door so there were lots of options. There is a massive mall about a block away that has other dining options as well.The only issue we ran into was a few taxi drivers refusing to take us to the Summer Palace because I guess they felt it wasn't far enough. The minimum rate is 10rmb. But the staff at the Four Points Sheraton (which is on a busier road than the side street for Aloft) were quite helpful in finding taxis for us if they weren't already there.We would definitely stay there again and recommend it to our friends for its excellent value. 
  </code></pre>
  <p>I created a DF for each hotel from the individual file names and added an ID using
  <code>beijingClean[&quot;ID&quot;] = beijingClean.index + 1</code>
  that looks like:</p>
  <pre><code>    Country City    Hotel   ID
  0   china   beijing aloft beijing haidian   1
  1   china   beijing ascott beijing  2
  2   china   beijing autumn garden courtyard hotel   3
  3   china   beijing bamboo garden hotel 4
  4   china   beijing beijing century towers  5
  </code></pre>
  <p>I need a way to create a second dataframe that holds the contents of the reviews for each hotel and references the ID generated from the initial dataframe.</p>
  <p>Using <code>df['text'].str.split('\t', expand=True)</code> I get this result:</p>
  <pre><code>0   1   2   3   4   5   6   7   8   9   ... 831 832 833 834 835 836 837 838 839 840
  0   Oct 12 2009 Nice trendy hotel location not too bad. I stayed in this hotel for one night. As this ...   \nSep 25 2009   Great Budget Hotel! Stayed two nights at Aloft on the most recent ...   \nAug 4 2009    Excellent value - location not a big problem.   We stayed at the Aloft Beijing Haidian for 5 n...   \nJul 17 2009   ... None    None    None    None    None    None    None    None    None    None
  1   Nov 17 2009 great room layout service value-would definite...   we stayed in a 3 bedroomed-suite which was wel...   \nNov 7 2009    A quality hotel with quality service    We stayed at the Ascott Beijing this summer fo...   \nOct 16 2009   clean rooms good location poor service  check-in:my friends are i arrived from differe...   \nSep 18 2009   ... None    None    None    None    None    None    None    None    None    None
  2       VERY NICE HOTEL We get vacation every year after my wedding. B...   \nNov 19 2009   A fantastic hotel   My boyfriend and I stayed in the Autumn Garden...   \nSep 11 2009   nice place to stay  The staff are extremely helpful and friendly, ...   \nDec 14 2008   ... None    None    None    None    None    None    None    None    None    None
  3   Oct 11 2009 A hidden gem    We stayed at this hotel for 4 nights at the st...   \nSep 23 2009   All we were hoping for was there    I booked this hotel based on the reviews I rea...   \nAug 16 2009   Great value for Money   Excellent room with own computer, great locati...   \nJul 29 2009   ... None    None    None    None    None    None    None    None    None    None
  
  </code></pre>
  <p>where each row contains all the information regarding the reviews for a particular hotel.</p>
  <p>I would like to create a data frame that looks like this:</p>
  <pre><code>Review ID | ID | Date | Review
  1    1   Oct 12 2009   Nice trendy hotel location not too bad...
  2    1   Sep 25 2009   Great Budget Hotel!...
  </code></pre>