Search code examples
python-3.xquandl

How to view the whole table


I am trying to get a table(dataset) using quandl. The table has 5rows X 12Columns but it is only showing 4 columns in the output and rest columns are replaced by 3 dots. I wrote the following piece of code using Python:

import quandl
df = quandl.get('WIKI/GOOGL')
print(df.head())

for the output please refer to this image. Click Here

P.S.: I tried using different IDEs for this code but the output was same.


Solution

  • I found the solution The following code will work perfectly:

    import pandas as pd
    import quandl
    df = quandl.get('WIKI/GOOGL')
    pd.set_option('display.max_columns', None)
    print(df.head())