1

I am trying to read CSV file by using python pandas, in the resultant dataframe one column is returned as float64 datatype instead of int64. But I could see most of the values are numbers and some of them are null values in the existing CSV file

df = pd.read_csv(file)

dh.head(3)

Name State  Id
SFO  CA     123.0
JFK  NY     152.0
CHG  IL     NaN
ABC  AZ     NaN

df.dypes

Name Object
State Object
Id float64

I tried convert Id column into Int64 to upload data into oracle table

df['Id'] = df['Id'].astype('int64')

Error : Cannot convert NA to integer

Is there any approach to convert Id column into int64 ? I appreciate your response.

N9909
  • 189
  • 1
  • 2
  • 23
  • Please provide a [mcve], as well as the entire error message. – AMC Mar 31 '20 at 01:03
  • 1
    Does this answer your question? [Convert Pandas column containing NaNs to dtype \`int\`](https://stackoverflow.com/questions/21287624/convert-pandas-column-containing-nans-to-dtype-int) – AMC Mar 31 '20 at 01:04

1 Answers1

1

In Python 3.7.6 and pandas 1.0.3 you can do:

df['Id'] = df['Id'].astype(pd.Int64Dtype())

print(df.dtypes)
print(df)

Output:

Name     object
State    object
Id        Int64

State    Id
0  SFO    CA   123
1  JFK    NY   152
2  CHG    IL  <NA>
3  ABC    AZ  <NA>
Chicodelarose
  • 827
  • 7
  • 22