Python in Alteryx - outputting column values count with original column values

[Kerria1276]

Hi, I am trying to output the results of a count on column values I am doing in the Python tool. I can print the results perfectly in the Jupyter notebook format, but when i try to output the same results I only get the count column, which is no use without the data the count is referring to. See my code below:

Any help greatly appreciated!

[Felipe_Ribeir0 · Accepted solution]

Hi @Kerria1276 

I had similar problems before with a column that was being used as an index for the dataframe if i remember well. I would try to reset index.

df = df.reset_index()

If this is not the case, i really dont know what could be.

[Kerria1276]

Thanks I will try that and let you know

[Kerria1276]

Thanks Felipe_Ribeir() that resolved it!