Do you want to avoid the difficulties of editing Cleaning Quote online? You don’t have to bother about downloading unreliable solutions or compromising your paperwork ever again. With DocHub, you can change date in Cleaning Quote without spending hours on it. And that’s not all; our user-friendly solution also provides you with highly effective data collection tools for gathering signatures, information, and payments through fillable forms. You can build teams using our collaboration capabilities and efficiently work together with multiple people on documents. On top of that, DocHub keeps your information safe and in compliance with industry-leading security standards.
DocHub enables you to use its tools regardless of your system. You can use it from your notebook, mobile phone, or tablet and modify Cleaning Quote easily. Begin working smarter right now with DocHub!
hello everyone so in this video i will be showing how to clean some of the aspects of a messy data set using some functions in excel so this particular data set was obtained from kaggle.com i will put a link to that data set in the description as a form of acknowledgement but as you can see from the data set its uh got some issues a couple of issues that stand out immediately are the dates so you can see that it doesnt have a date only it also have the timestamp in it so you got the hour and then plus zero zero im guessing thats the millisecond or something like that so we need to convert this into a proper date format the other issue that you can see in this data set is that its got a product category three so its got the category here clothing furniture and so forth and then its got the subcategories subcategory and then ultimately its got um the product name now this product name is essentially the same as these products here most of them uh the brand names in this day parti