Pandas: Converting to numeric, creating NaNs when necessary

by

In pandas 0.17.0 convert_objects raises a warning:

FutureWarning: convert_objects is deprecated. Use the data-type
specific converters pd.to_datetime, pd.to_timedelta and pd.to_numeric.

You could use pd.to_numeric method and apply it for the dataframe with arg coerce.

df1 = df.apply(pd.to_numeric, args=('coerce',))

or maybe more appropriately:

df1 = df.apply(pd.to_numeric, errors="coerce")

EDIT

The above method is only valid for pandas version >= 0.17.0, from docs what’s new in pandas 0.17.0:

pd.to_numeric is a new function to coerce strings to numbers (possibly with coercion) (GH11133)

More Related Contents:

  1. How to one-hot-encode from a pandas column containing a list?
  2. Rename Pandas DataFrame Index
  3. Pandas DataFrame stored list as string: How to convert back to list
  4. Merge pandas dataframes where one value is between two others [duplicate]
  5. Convert Column to Date Format (Pandas Dataframe)
  6. Merge multiple column values into one column in python pandas
  7. How to add multiple annotations to a barplot
  8. How do I get the row count of a Pandas DataFrame?
  9. How to save the Pandas dataframe/series data as a figure?
  10. Apply CSS class to Pandas DataFrame using to_html
  11. Plotting categorical data with pandas and matplotlib
  12. Setting values on a copy of a slice from a DataFrame [duplicate]
  13. How can I replicate rows in Pandas?
  14. pandas – get most recent value of a particular column indexed by another column (get maximum value of a particular column indexed by another column)
  15. Seaborn ValueError: zero-size array to reduction operation minimum which has no identity
  16. How to create a DataFrame of random integers with Pandas?
  17. summing two columns in a pandas dataframe
  18. add a row at top in pandas dataframe [duplicate]
  19. Find difference between two data frames
  20. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  21. Specifying date format when converting with pandas.to_datetime
  22. Bar graph from dataframe groupby
  23. Grouped Bar graph Pandas
  24. KeyError when indexing Pandas dataframe
  25. pandas group by and assign a group id then ungroup
  26. how to save a pandas DataFrame to an excel file?
  27. Excel VLOOKUP equivalent in pandas
  28. Seaborn multiple barplots
  29. Add density curve on the histogram
  30. pandas scatter plotting datetime

Leave a Comment