How can I read a file with complex number and convert to numpy array as complex datatype?

Question

I have a .excel file with complex number data and want it to convert to complex numpy array.

I tried the following code:

df=pd.read_excel(location, sheet_name='complex')

np_complex=df.to_numpy(dtype=complex)

It has worked previously, although nothing is changed (I think) but now it is raising the error

TypeError: must be real number, not str

In line np_complex=df.to_numpy(dtype=complex)

Can anyone suggest the change in code?

We need more information. Where did the error occur? What was different previously vs now? — hpaulj
– hpaulj, Commented Jun 1, 2021 at 2:46
@hpaulj Error occured in the line "np_complex=df.to_numpy(dtype=complex)", although I do not think any thing has been changed in the excel file and code too. — Abanish Tiwari
– Abanish Tiwari, Commented Jun 1, 2021 at 2:56
have a look at df.dtypes to make sure the data types are correct — Jan Wilamowski
– Jan Wilamowski, Commented Jun 1, 2021 at 3:17
Could you show part of df.to_numpy()? This should give a clearer idea of what it's trying to convert to complex. In my tests "1+3j" and "(1+3j)"` both work. — hpaulj
– hpaulj, Commented Jun 1, 2021 at 3:29

Shubham luharuka · Accepted Answer · 2021-06-01 13:53:45Z

0

Your code is right. Try to rebuild then run. When I run this code it works fine my IDE. This is code Code and its result Result.

answered Jun 1, 2021 at 13:53

Shubham luharuka

111 silver badge3 bronze badges

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

1 Answer 1