When your daily tasks scope consists of a lot of document editing, you know that every document format requires its own approach and sometimes specific software. Handling a seemingly simple csv file can sometimes grind the entire process to a halt, especially when you are trying to edit with inadequate tools. To avoid this kind of difficulties, get an editor that will cover all your needs regardless of the file format and clean date in csv without roadblocks.
With DocHub, you are going to work with an editing multitool for virtually any occasion or document type. Minimize the time you used to spend navigating your old software’s features and learn from our intuitive interface design as you do the work. DocHub is a streamlined online editing platform that handles all your document processing needs for virtually any file, such as csv. Open it and go straight to efficiency; no prior training or reading manuals is needed to enjoy the benefits DocHub brings to document management processing. Start by taking a few minutes to register your account now.
See upgrades in your document processing right after you open your DocHub profile. Save time on editing with our one solution that can help you be more productive with any document format with which you need to work.
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