Remove non-numeric rows in one column with pandas

by

Using pd.to_numeric

In [1079]: df[pd.to_numeric(df['id'], errors="coerce").notnull()]
Out[1079]:
  id  name
0  1     A
1  2     B
2  3     C
4  4     E
5  5     F

More Related Contents:

  1. how to calculation cost time [closed]
  2. Pandas: Adding new column to dataframe which is a copy of the index column
  3. pandas: filter rows of DataFrame with operator chaining
  4. Pandas groupby: How to get a union of strings
  5. How do I create test and train samples from one dataframe with pandas?
  6. pandas groupby sort within groups
  7. Applying function with multiple arguments to create a new pandas column
  8. Python Pandas max value in a group as a new column
  9. Convert columns to string in Pandas
  10. What is the difference between using loc and using just square brackets to filter for columns in Pandas/Python?
  11. Pandas: Cast column to string does not work
  12. How to query MultiIndex index columns values in pandas
  13. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  14. Add multiple empty columns to pandas DataFrame
  15. No numeric types to aggregate – change in groupby() behaviour?
  16. OSError: Initializing from file failed on csv in Pandas
  17. Line plot with data points in pandas
  18. Python & Pandas: How to query if a list-type column contains something?
  19. Remove Unnamed columns in pandas dataframe [duplicate]
  20. Pandas: Reading Excel with merged cells
  21. Pandas groupby with categories with redundant nan
  22. Datetime conversion – How to extract the inferred format?
  23. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  24. Slicing multiple ranges of columns in Pandas, by list of names
  25. What values are valid in Pandas ‘Freq’ tags?
  26. reading multiple files contained in a zip file with pandas
  27. How to filter a DataFrame column of lists for those that contain a certain item
  28. Excel VLOOKUP equivalent in pandas
  29. Seaborn multiple barplots
  30. pandas scatter plotting datetime

Leave a Comment