Time is a crucial resource that every enterprise treasures and tries to convert in a reward. When selecting document management software, pay attention to a clutterless and user-friendly interface that empowers users. DocHub provides cutting-edge tools to improve your file administration and transforms your PDF editing into a matter of one click. Delete Date Field from the Christmas Bonus Letter with DocHub to save a ton of efforts and increase your efficiency.
Make PDF editing an easy and intuitive operation that helps save you plenty of valuable time. Quickly modify your files and send out them for signing without adopting third-party solutions. Focus on pertinent tasks and boost your file administration with DocHub starting today.
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 parti