yfinance Python tool - Omitting columns on output

GWYAlex

Hi everyone,

Potentially newb Python question here - but just wondering how do I output the date column? The nodates screenshot is the code I'm working with, and the -hasdates columns is from a Macro which @jarrod created and I'm just having a cheeky inspection of.

I am also using the .get_financials function, but it too only provides four value columns, and is missing the descriptors such as "earnings" "net debt ratio", etc.

How do I get Alteryx to display these columns? Any help here would be greatly appreciated.

Thanks heaps.

A

Python-yfinancenodates.PNG

Python-yfinance-datesshowing.PNG

KilianL

Hi @GWYAlex ,

that is a strange error.

I replicated it myself and the Date column seems to be missing the column header and is not being picked up by Alteryx in the output.

I was able to get the header back by adding: data.reset_index(level=0, inplace=True)

You can find this in the other example you showed also. See my testing below:

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.

Kind Regards,
Kilian
Solutions Engineer - Alteryx