With DocHub, you can easily wipe out date in excel from anywhere. Enjoy features like drag and drop fields, editable text, images, and comments. You can collect eSignatures safely, include an additional layer of defense with an Encrypted Folder, and work together with teammates in real-time through your DocHub account. Make adjustments to your excel files online without downloading, scanning, printing or sending anything.
You can find your edited record in the Documents tab of your account. Edit, email, print out, or convert your file into a reusable template. Considering the variety of powerful features, it’s simple to enjoy effortless document editing and management 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 itamp;#39;s uh got some issues a couple of issues that stand out immediately are the dates so you can see that it doesnamp;#39;t have a date only it also have the timestamp in it so you got the hour and then plus zero zero iamp;#39;m guessing thatamp;#39;s 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 itamp;#39;s got a product category three so itamp;#39;s got the category here clothing furniture and so forth and then itamp;#39;s got the subcategories subcategory and then ultimately itamp;#39;s got um the product name now this product name is essentially the same as these