Convert ndarray to pandas dataframe

Question

I am trying to just get the unique values of a pandas column into a new pandas dataframe as such:

res = df.resolution.unique()
a = pd.DataFrame()
a['Unique Resolution Types'] = pd.DataFrame(res)

But I am getting this error:

ValueError: Cannot set a frame with no defined index and a value that cannot be converted to a Series

I tried converting res into a list but still the same error. How do I resolve this?

Onur AKKÖSE · Accepted Answer · 2020-11-06 18:37:55Z

1

It is not correct to write pd.Dataframe(res);

res = df.resolution.unique()
a = pd.DataFrame()
a['Unique Resolution Types'] = res

Now, it will work.

answered Nov 6, 2020 at 18:37

Onur AKKÖSE

1023 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

'a' is already a dataframe. You fill in the 'a' dataframe with res.

a = pd.DataFrame(res, columns=['Unique...']) is correct.

For code block in comments use tilde i.e. ` .Cheers good day mate. ;)