Removing the last 10 characters from a string and converting it to a numeric variable

[ballardw]

---

@Vicente95 wrote:

I agree with what you said, however I was assigned this dataset as my personal project. There is not much that I could do other than use it. 

---

What is the purpose of the project? Is it to learn how to clean data? If not, then this a fairly ugly data set to use for anything else as it likely requires lots of cleaning and cylinders is just one of the bits that is going to have issues.

One thing you may want to consider is that Craislist is very likely going to have multiple listings for the exact same car with the asking price changing periodically. I'm not going to pull that data set to verify but I have looked for some specific cars on Craigslist and with limited searches ran into the multiple listings for the same car by the same seller very quickly. So maybe you can reduce some of the problem by getting to a single listing per actual car. Dealer listing may make this harder as they may have multiple similar models.