Python output "News Headline" not completely displayed

Hello dear community,

I would like to generate a dataset that captures the news about a stock in a period of time.

However, under the code described in the photo is not displayed in full, but with ... for two columns shortened. I am using PyCharm.

Can someone help me in this case?

Thanks a lot already!

With kind regards

Lukas Rohde

Find more posts tagged with

python api

workspace

eikon-data-api

Accepted answers

wasin.w

Hello @infojw

By default, the Pandas also displays only a limited number of columns.

However, you can use the Pandas option_context() method to set a temporary number of columns:

Example:

import pandas as pd
...
# Request data
with pd.option_context('display.max_columns', None):
    print(newsheadlines)

Result:

Note: Since you are printing the Pandas dataframe in a console, so there are some limitations on displaying long data. The dataframe is designed to be displayed on the IPython environment such as Jupyter Noteboook/Julyterlab, not a console.

Hope this helps.

All comments

wasin.w

Hello @infojw

By default, the Pandas also displays only a limited number of columns.

However, you can use the Pandas option_context() method to set a temporary number of columns:

Example:

import pandas as pd
...
# Request data
with pd.option_context('display.max_columns', None):
    print(newsheadlines)

Result:

Hope this helps.

infojw

Hello wasin.w,

thank you very much for your detailed answer!

Would you say it is better for me to switch to Jupyter Notebook?

I am a beginner in Python and I am trying to allocate financial messages to a sentiment using a bag-of-words approach.

Many greetings

Lukas Rohde

wasin.w

Hello @infojw

JupyterLab/Jupyter notebook is a better environment for learning and exploring Python than a Python console.

You can find the Eikon Data API tutorial with Jupyter on this Python Quants Video Tutorial Series page.

The hardest step is to install Jupyter, you can find more resources on the internet such as:

Hope this helps.

infojw

Thank you very much!

best regards

Lukas Rohde

EXPLORE OUR SITES