title: Why doesn't my python pandas code shows a table?
body: <p>I am using Spyder and the following source code:</p>
  <pre><code>import pandas as pd
  
  
  filename = &quot;file.csv&quot; # 5.35 GB in size
  
  df = pd.read_csv(filename, nrows=5)
  pd.set_option('display.max_columns', None)
  
  df
      
  </code></pre>
  <p><strong>Output</strong></p>
  <pre><code>runfile('C:/Users/pc/Desktop/Data Mining/file.py', wdir='C:/Users/pc/Desktop/Data Mining/')
  Reloaded modules: jupyter_client.session, zmq.eventloop, zmq.eventloop.ioloop, 
  tornado.platform, tornado.platform.asyncio, tornado.gen, zmq.eventloop.zmqstream, 
  jupyter_client.jsonutil, jupyter_client.adapter, spyder, spyder.pil_patch, PIL, 
  PIL._version, PIL.Image, PIL.ImageMode, PIL.TiffTags, PIL._binary, PIL._util, PIL._imaging, 
  cffi, cffi.api, cffi.lock, cffi.error, cffi.model
  </code></pre>
  <p>Why doesn't my python pandas code show a table?</p>
  <hr />
  <p>Also, after using print<code>(df)</code> :</p>
  <pre><code>import pandas as pd
  
  
  filename = &quot;clash_royale_games_Jan_2019.csv&quot;
  
  
  df = pd.read_csv(filename, nrows=5)
  pd.set_option('display.max_columns', None)
  print(df)
  </code></pre>
  <p><strong>Output</strong></p>
  <pre><code>runfile('C:/Users/pc/Desktop/Data Mining/file.py', wdir='C:/Users/pc/Desktop/Data Mining/')
  Reloaded modules: jupyter_client.session, zmq.eventloop, zmq.eventloop.ioloop, tornado.platform, tornado.platform.asyncio, tornado.gen, zmq.eventloop.zmqstream, jupyter_client.jsonutil, jupyter_client.adapter, spyder, spyder.pil_patch, PIL, PIL._version, PIL.Image, PIL.ImageMode, PIL.TiffTags, PIL._binary, PIL._util, PIL._imaging, cffi, cffi.api, cffi.lock, cffi.error, cffi.model
                timestamp  arena_id  has_won        tag  \
  0  2018-12-31T23:00:46Z        16        1  289VVL288   
  1  2018-12-31T23:01:34Z        14        1  2G0PRYVRU   
  2  2018-12-31T23:02:00Z        13        1   92GLVGQU   
  3  2018-12-31T23:02:00Z        14        1  2Y28RPJRC   
  4  2018-12-31T23:02:02Z        16        0    8RYLV2R   
  
                                           player_deck  
  0  elixir-collector_golem_mega-knight_mega-minion...  
  1  dark-prince_goblin-gang_miner_pekka_the-log_to...  
  2  baby-dragon_balloon_barbarian-barrel_bowler_fr...  
  3  baby-dragon_fireball_inferno-dragon_mega-minio...  
  4  archers_barbarian-barrel_goblins_hog-rider_kni...  
  </code></pre>
  <p>You see the 5th column is truncated.</p>
  <p>How can I show the 5th column in full?</p>