NumPy or Pandas: Keeping array type as integer while having a NaN value

by

NaN can’t be stored in an integer array. This is a known limitation of pandas at the moment; I have been waiting for progress to be made with NA values in NumPy (similar to NAs in R), but it will be at least 6 months to a year before NumPy gets these features, it seems:

http://pandas.pydata.org/pandas-docs/stable/gotchas.html#support-for-integer-na

(This feature has been added beginning with version 0.24 of pandas, but note it requires the use of extension dtype Int64 (capitalized), rather than the default dtype int64 (lower case):
https://pandas.pydata.org/pandas-docs/version/0.24/whatsnew/v0.24.0.html#optional-integer-na-support
)

More Related Contents:

  1. Pandas: Subtracting two date columns and the result being an integer
  2. Replacing values represented by 'UN' with NaN
  3. What is the difference between NaN and None?
  4. String concatenation of two pandas columns
  5. Strings in a DataFrame, but dtype is object
  6. Performance of Pandas apply vs np.vectorize to create new column from existing columns
  7. What does axis in pandas mean?
  8. FutureWarning: elementwise comparison failed; returning scalar, but in the future will perform elementwise comparison
  9. Convert bytes to int?
  10. Import pandas dataframe column as string not int
  11. How to map numeric data into categories / bins in Pandas dataframe
  12. Coalesce values from 2 columns into a single column in a pandas dataframe
  13. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  14. Pandas reading csv as string type
  15. ‘DataFrame’ object has no attribute ‘sort’
  16. Pandas pd.Series.isin performance with set versus array
  17. Difference between data type ‘datetime64[ns]’ and ‘
  18. python pandas flatten a dataframe to a list
  19. Precision lost while using read_csv in pandas
  20. Get week start date (Monday) from a date column in Python (pandas)?
  21. What is dtype(‘O’), in pandas?
  22. pandas distinction between str and object types
  23. NumPy version of “Exponential weighted moving average”, equivalent to pandas.ewm().mean()
  24. Pandas: Difference between largest and smallest value within group
  25. Convert Pandas series containing string to boolean
  26. Add numpy array as column to Pandas data frame
  27. Stratified Sampling in Pandas
  28. Load CSV to Pandas MultiIndex DataFrame
  29. Python pandas – new column’s value if the item is in the list
  30. Why is NaN considered as a float?

Leave a Comment