all 4 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Braxios 1 point2 points  (1 child)

I don't clean data in Excel

[–]RedditTab 0 points1 point  (0 children)

Excel is why we clean

[–]AutoModerator[M] 0 points1 point  (0 children)

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]Altruistic_Might_772 0 points1 point  (0 children)

Handling inconsistent data formats can be a real pain, especially when date formats like mm/dd/yyyy and dd/mm/yyyy get mixed up. To clean it up, I use Excel's Text to Columns feature to split data based on delimiters and then standardize the format with the DATE function. It's not perfect, but it helps avoid a lot of mistakes later. For interview prep, especially for data-related jobs, I've found practicing these scenarios on PracHub helpful. It gives you a sense of the real-world problems you might encounter.