As the error states, you can only use .str
with string columns, and you have a float64
. There won’t be any commas in a float, so what you have won’t really do anything, but in general, you could cast it first:
dc_listings['price'].astype(str).str.replace...
For example:
In [18]: df Out[18]: a b c d e 0 0.645821 0.152197 0.006956 0.600317 0.239679 1 0.865723 0.176842 0.226092 0.416990 0.290406 2 0.046243 0.931584 0.020109 0.374653 0.631048 3 0.544111 0.967388 0.526613 0.794931 0.066736 4 0.528742 0.670885 0.998077 0.293623 0.351879 In [19]: df['a'].astype(str).str.replace("5", " hi ") Out[19]: 0 0.64 hi 8208 hi hi 4779467 1 0.86 hi 7231174332336 2 0.04624337481411367 3 0. hi 44111244991 hi 194 4 0. hi 287421814241892 Name: a, dtype: object
Related Posts:
- Renaming column names in Pandas
- How to deal with SettingWithCopyWarning in Pandas
- How to deal with SettingWithCopyWarning in Pandas
- How to iterate over rows in a DataFrame in Pandas
- Writing a pandas DataFrame to CSV file
- Adding new column to existing DataFrame in Python pandas
- ImportError: No module named pandas
- How to change the order of DataFrame columns?
- How to change the order of DataFrame columns?
- ImportError: No module named pandas. Pandas installed pip
- What does `ValueError: cannot reindex from a duplicate axis` mean?
- How can I use the apply() function for a single column?
- Convenient way to deal with ValueError: cannot reindex from a duplicate axis
- How to fix IndexError: invalid index to scalar variable
- “Series objects are mutable and cannot be hashed” error
- Merging dataframes on index with pandas
- Create a Pandas Dataframe by appending one row at a time
- Convert Python dict into a dataframe
- re.sub erroring with “Expected string or bytes-like object”
- How do I select rows from a DataFrame based on column values?
- How do I select rows from a DataFrame based on column values?
- DataFrame constructor not properly called! error
- Pandas group-by and sum
- How do I get the row count of a Pandas DataFrame?
- Python pandas groupby aggregate on multiple columns, then pivot
- Convert pandas dataframe to NumPy array
- Error:cannot convert float NaN to integer in pandas
- Replacing column values in a pandas DataFrame
- How do I get the row count of a Pandas DataFrame?
- Python Pandas – Missing required dependencies [‘numpy’] 1
- Get list from pandas dataframe column or row?
- pandas DataFrame “no numeric data to plot” error
- ‘DataFrame’ object has no attribute ‘sort’
- TypeError: cannot unpack non-iterable int objec
- Pandas DataFrame column to list
- Rename Pandas DataFrame Index
- pandas: filter rows of DataFrame with operator chaining
- Convert DataFrame column type from string to datetime, dd/mm/yyyy format
- Pandas how to use pd.cut()
- How to Read .txt in Pandas
- Get a list from Pandas DataFrame column headers
- Get total of Pandas column
- Type error: cannot convert the series to
- How to check whether a pandas DataFrame is empty?
- Convert columns to string in Pandas
- Change column type in pandas
- Shuffle DataFrame rows
- Python: pandas merge multiple dataframes
- How to load a tsv file into a Pandas DataFrame?
- How to count the NaN values in a column in pandas DataFrame
- How to iterate over columns of pandas dataframe to run regression
- JSON to pandas DataFrame
- Converting between datetime and Pandas Timestamp objects
- Pandas – DataFrame object is not callable
- Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
- Convert pandas data frame to series
- Converting strings to floats in a DataFrame
- Get first row value of a given column
- Selecting/excluding sets of columns in pandas
- How to add title to seaborn boxplot
- How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
- How to add an empty column to a dataframe?
- Deleting DataFrame row in Pandas based on column value
- Map to List error: Series object not callable
- How to apply a function to two columns of Pandas dataframe
- Pandas long to wide reshape, by two variables
- Convert categorical data in pandas dataframe
- pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
- SettingWithCopyWarning even when using .loc[row_indexer,col_indexer] = value
- OSError: Initializing from file failed on csv in Pandas
- Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
- Python Pandas ValueError Arrays Must be All Same Length
- Plot correlation matrix using pandas
- Plotting multiple lines, in different colors, with pandas dataframe
- Groupby value counts on the dataframe pandas
- TypeError: cannot concatenate a non-NDFrame object
- Rename specific column(s) in pandas
- Pandas – Drop function error (label not contained in axis)
- Pandas index column title or name
- ImportError: No module named ‘xlrd’
- Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
- Moving Average Pandas
- import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
- How to add pandas data to an existing csv file?
- Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
- python pandas remove duplicate columns
- matplotlib: plot multiple columns of pandas data frame on the bar chart
- Concat DataFrame Reindexing only valid with uniquely valued Index objects
- Replacing Pandas or Numpy Nan with a None to use with MysqlDB
- pandas replace multiple values one column
- Convert floats to ints in Pandas?
- pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
- Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
- Python: Convert timedelta to int in a dataframe
- Calculate weighted average using a pandas/dataframe
- Got continuous is not supported error in RandomForestRegressor
- Extract first and last row of a dataframe in pandas
- ValueError: multiclass format is not supported
- ValueError: Must pass DataFrame with boolean values only
- Extracting specific selected columns to new DataFrame as a copy