Question: python, pandas Removing unwanted element from dataframe. Let say, in the example below in my data frame, df, i need to remove '4528.' from all

python, pandas
Removing unwanted element from dataframe. Let say, in the example below in my data frame, df, i need to remove '4528.' from all the entries. I tried:
df.str.replace('4528.', '')
but this gives me an error 'DataFrame object has no attribute 'str'
i also tried just df.replace('4528.', '') but it blanked the entire df. please advise a simple way to do the magic.
python, pandas Removing unwanted element from dataframe. Let say, in the example

b. C. b

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Taxi Trip Records in New York City Data Analysis Assignment Introduction In this data analysis assignment, we will explore, clean, analyze, and visualize the Taxi Trip Records in New York City...

Q:

Using Python Pandas analyze the HURDAT2 data and answer the following questions. The link to the CSV file can be found here: http://www.cis.umassd.edu/~dkoop/dsc201-2018fa/assignment3.html Each data...

Q:

Complete in Python with comments, thank you. Recall that stacks and queues are abstract data types ( ADTs ) . They support certain basic operations, but these operations can be implemented in...

Q:

PYTHON 7.7 Our CircularQueue class of Section 7.2.2 provides a rotate( ) method that has semantics equivalent to Q.enqueue(Q.dequeue()), for a nonempty queue. Implement such a method for the...

Q:

The goal of this project is to analyze real - world data to find interesting trends or insights. Students will utilize Python, Pandas, Matplotlib, and Jupyter Notebooks to conduct their analysis and...

Q:

Python data frame pandas removing 0 I have a data frame with a header location in the location i have multiple types and I need to remove the zero from the 5 so the became just 5 without 0. id...

Q:

Create a data ware house using data lake. Create three layers. Bronze, Silver and Gold You will dump data from at least two sources in the Bronze area. You will do the transformation including...

Q:

In Python pandas package, I ran this code to find the element with the max value. Now, I want to find the indexes of this value ie the row and column it is located in and I can't quite figure out...

Q:

I need help creating a new DataFrame in PYTHON PANDAS. df = pd.read_csv("https://www.stat.berkeley.edu/~statlabs/data/babies.data", delim_whitespace=True) df.head(10) #This is where I am extracting...

Q:

Consider a scheduling problem, where there are eight variables A, B, C, D, E, F, G, H each with domain {1, 2, 3, 4}. Suppose the constraints are: A > G, A H, |F B| = 1, G

Q:

In the chapter opening, we discussed the cash positions of several companies. Automobile manufactures also have enormous cash reserves. At the beginning of 2007, Ford Motor Co. had $38.7 billion in...

Q:

CASH PAID FOR OPERATING EXPENSES The following information was obtained from Busby Company's income statement for 20-2, balance sheets as of December 31, 20-2 and 20-1, and auxiliary records:...

Q:

umbridge purses unlimited sells purses with a sales price of 2 5 . 0 0 each. each purse costs the company 2 0 . 0 0 to produce, and the store incurs a total of 2 1 0 0 0 0 in fixed costs each year....

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

1. What business benefits do cloud computing services provide? What problems do they solve? Cloud computing is taking off. The biggest players in the cloud computing marketplace include Amazon Web...

Q:

3. What are the business benefits and costs of these solutions? Whats too hot to handle? It might very well be your companys data center, which can easily consume more than 100 times more power than...

Q:

1. What business and social problems does data center power consumption cause? Whats too hot to handle? It might very well be your companys data center, which can easily consume more than 100 times...