Whether you are already used to working with xls or handling this format the very first time, editing it should not feel like a challenge. Different formats might require specific apps to open and edit them properly. Yet, if you have to swiftly clean date in xls as a part of your typical process, it is advisable to get a document multitool that allows for all types of such operations without extra effort.
Try DocHub for sleek editing of xls and also other file formats. Our platform offers easy document processing no matter how much or little previous experience you have. With all instruments you need to work in any format, you will not have to jump between editing windows when working with each of your files. Effortlessly create, edit, annotate and share your documents to save time on minor editing tasks. You will just need to register a new DocHub account, and then you can begin your work immediately.
See an improvement in document management efficiency with DocHub’s simple feature set. Edit any file quickly and easily, irrespective of its format. Enjoy all the advantages that come from our platform’s efficiency and convenience.
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 part