When you edit files in different formats day-to-day, the universality of your document solution matters a lot. If your tools work with only a few of the popular formats, you might find yourself switching between software windows to clean date in spreadsheet and manage other document formats. If you want to eliminate the headache of document editing, go for a solution that can effortlessly manage any extension.
With DocHub, you do not need to concentrate on anything short of the actual document editing. You will not have to juggle programs to work with diverse formats. It can help you revise your spreadsheet as effortlessly as any other extension. Create spreadsheet documents, edit, and share them in a single online editing solution that saves you time and boosts your productivity. All you need to do is register a free account at DocHub, which takes only a few minutes.
You will not have to become an editing multitasker with DocHub. Its functionality is sufficient for speedy document editing, regardless of the format you want to revise. Start by creating a free account to see how effortless document management might be with a tool designed specifically to suit your needs.
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