Whether you are already used to working with spreadsheet or managing this format the very first time, editing it should not seem like a challenge. Different formats might require particular applications to open and edit them properly. Yet, if you need to swiftly wipe date in spreadsheet as a part of your typical process, it is best to find a document multitool that allows for all types of such operations without the need of additional effort.
Try DocHub for sleek editing of spreadsheet and other file formats. Our platform offers effortless papers processing regardless of how much or little prior experience you have. With tools you have to work in any format, you won’t have to jump between editing windows when working with each of your documents. Effortlessly create, edit, annotate and share your documents to save time on minor editing tasks. You’ll just need to register a new DocHub account, and you can begin your work right away.
See an improvement in document processing productivity with DocHub’s straightforward feature set. Edit any file easily and quickly, regardless of its format. Enjoy all the benefits that come from our platform’s simplicity 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