I loaded mat file and I get followed dictionary.
| key | Value |
|---|---|
| A | [[Numpy array],[Numpy array],...] |
| B | [[Numpy array],[Numpy array],...] |
| ... | ... |
So, I changed this dictionary to Dataframe using X = pd.Dataframe.from_dict(Y)
| Index | A | B | ... |
|---|---|---|---|
| 0 | [array(0.)] | [array(10.)] | ... |
| 1 | [array(1.)] | [array(11.)] | ... |
| ... | ... | ... | ... |
But, I expect to followed dataframe.
| Index | A | B | ... |
|---|---|---|---|
| 0 | 0. | 10. | ... |
| 1 | 1. | 11. | ... |
| ... | ... | ... | ... |
(The single value type whether int or float is not important to me.)
How can change numpy array to single value?
Thanks for your help.
CodePudding user response:
It looks like the elements in your dataframe are lists with a single element. To get rid of that, you can simply use the pandas method explode. So in your case, X = X.explode(['A','B']) for all your columns. If you still struggle having numpy arrays instead of floats, X = X.astype(float) should do the trick.
