title: python - Reading a .csv with multiple languages in column
body: <p>I am trying to explore the recently posted Russion investigation tweets database. First of 9 csv files here:
  <a href="https://raw.githubusercontent.com/fivethirtyeight/russian-troll-tweets/master/IRAhandle_tweets_1.csv" rel="nofollow noreferrer">https://raw.githubusercontent.com/fivethirtyeight/russian-troll-tweets/master/IRAhandle_tweets_1.csv</a></p>
  
  <p>The dataset has a column "content" with the tweet content. Tweets are in more than 50 languages. </p>
  
  <p>Any way to read the .csv with such an encoding that at least Latin + Cyrillic tweets are displayed properly in the same dataset? </p>
  
  <p>I tried pd.read_csv with UTF-8 and cp1251, but no success so far. Latin tweets are displayed properly, Cyrillic - not. </p>
  
  <p>For example, line 372 in the file, read as binary, has the following value:</p>
  
  <pre><code>(b'2528776985,1488REASONS,"\xc3\x90\xc2\x9f\xc3\x91\xc2\x80\xc3\x90\xc2\xb8'
   b'\xc3\x91\xc2\x87\xc3\x90\xc2\xb8\xc3\x90\xc2\xbd\xc3\x90\xc2\xb0 #67'
   b' \xc3\x90\xc2\x9c\xc3\x91\xc2\x83\xc3\x91\xc2\x82\xc3\x90\xc2'
   b'\xba\xc3\x90\xc2\xbe: \xc3\x82\xc2\xab\xc3\x90\xc2\x97\xc3\x90\xc2\xb5\xc3'
   b'\x90\xc2\xbd\xc3\x90\xc2\xb8\xc3\x91\xc2\x82-\xc3\x90\xc2\x90'
   b'\xc3\x91\xc2\x80\xc3\x90\xc2\xb5\xc3\x90\xc2\xbd\xc3\x90\xc2\xb5'
   b'\xc3\x82\xc2\xbb \xc3\x90\xc2\xb4\xc3\x90\xc2\xbb\xc3\x91\xc2\x8f \xc3\x90'
   b'\xc2\xb0\xc3\x90\xc2\xb4\xc3\x90\xc2\xb0\xc3\x90\xc2\xbf\xc3\x91'
   b'\xc2\x82\xc3\x90\xc2\xb0\xc3\x91\xc2\x86\xc3\x90\xc2\xb8\xc3\x90'
   b'\xc2\xb8 \xc3\x90\xc2\xba \xc3\x90\xc2\xa7\xc3\x90\xc2\x9c \xc3\x90\xc2'
   b'\xbf\xc3\x90\xc2\xbe\xc3\x91\xc2\x82\xc3\x91\xc2\x80\xc3\x90\xc2'
   b'\xb5\xc3\x90\xc2\xb1\xc3\x91\xc2\x83\xc3\x90\xc2\xb5\xc3\x91\xc2'
   b'\x82\xc3\x91\xc2\x81\xc3\x91\xc2\x8f 1,5\xc3\xa2\xc2\x80\xc2\x932'
   b' \xc3\x90\xc2\xbc\xc3\x90\xc2\xbb\xc3\x91\xc2\x80\xc3\x90\xc2\xb4 \xc3\x91'
   b'\xc2\x80\xc3\x91\xc2\x83\xc3\x90\xc2\xb1\xc3\x90\xc2\xbb\xc3\x90'
   b'\xc2\xb5\xc3\x90\xc2\xb9",Unknown,Russian,1/19/2017 13:07,1/19/2017 13:07,'
   b'6311,6313,1806,,Russian,0,0,NonEnglish\r\n')
  </code></pre>
  
  <p>so when decoding as UTF-8 the <code>content</code> value becomes:</p>
  
  <pre><code>('Ð\x9fÑ\x80Ð¸Ñ\x87Ð¸Ð½Ð° #67 Ð\x9cÑ\x83Ñ\x82ÐºÐ¾: '
   'Â«Ð\x97ÐµÐ½Ð¸Ñ\x82-Ð\x90Ñ\x80ÐµÐ½ÐµÂ» Ð´Ð»Ñ\x8f Ð°Ð´Ð°Ð¿Ñ\x82Ð°Ñ\x86Ð¸Ð¸ Ðº '
   'Ð§Ð\x9c Ð¿Ð¾Ñ\x82Ñ\x80ÐµÐ±Ñ\x83ÐµÑ\x82Ñ\x81Ñ\x8f 1,5â\x80\x932 Ð¼Ð»Ñ\x80Ð´ '
   'Ñ\x80Ñ\x83Ð±Ð»ÐµÐ¹')
  </code></pre>
  
  <p>which prints as</p>
  
  <pre><code>ÐÑÐ¸ÑÐ¸Ð½Ð° #67 ÐÑÑÐºÐ¾: Â«ÐÐµÐ½Ð¸Ñ-ÐÑÐµÐ½ÐµÂ» Ð´Ð»Ñ Ð°Ð´Ð°Ð¿ÑÐ°ÑÐ¸Ð¸ Ðº Ð§Ð Ð¿Ð¾ÑÑÐµÐ±ÑÐµÑÑÑ 1,5â2 Ð¼Ð»ÑÐ´ ÑÑÐ±Ð»ÐµÐ¹
  </code></pre>