PinnedMichael T VuHow to Convert LEFT(), MID() and RIGHT() into RTo begin with the topic today, let’s have a look on this scenario. Imagine when you have a dataset with multiple fields and there might be…Nov 3, 20221Nov 3, 20221
PinnedMichael T VuSwap First and Last Name in RIn the last article, we discussed how we converted LEFT(), MID() and RIGHT() function from Excel to R. Today we will find out how to swap…Nov 9, 2022Nov 9, 2022
Michael T VuExploring the Exciting Future of Data Analysis and AI: Advancements, Challenges, and ImpactsThe Future of Data Analysis and AI: A Look AheadFeb 10, 2023Feb 10, 2023
Michael T VuMastering Time Management: How to Effectively Prioritize and Meet Deadlines with ExcelWe all have a to-do list that we need to complete, whether it’s for work, school, or personal projects. However, with so many tasks to…Jan 17, 2023Jan 17, 2023
Michael T VuinDev GeniusWhat You Need To Know To Become A Data AnalystBecoming a data analyst and things you need to know.Jan 8, 20232Jan 8, 20232
Michael T VuinDev GeniusTurning Calendar Year To Fiscal Year in RAn idea flashes into my mind, so I start noting it down right away in case I might forget after that. Today’s focus will be how to turn…Dec 20, 20222Dec 20, 20222
Michael T VuinDev GeniusHow To Convert Date Format in RRecently I have worked on multiple projects including date time fields in the datasets. Most of the time I need to convert the date time…Dec 15, 20222Dec 15, 20222
Michael T VuinDev GeniusR for Haters: How To Extract Word/Number Inside ParenthesesWhen working with people data, I have many chances to deal with name and an extra parenthesis with information inside such as year of…Dec 5, 20221Dec 5, 20221
Michael T VuImport Data from Clipboard into RSometimes you might wonder how to import the copied data from clipboard into R. Especially when you are working on big projects, you need…Nov 24, 2022Nov 24, 2022
Michael T VuClean Imported Data Headers in RHave you ever been tired of renaming headers when you import new data files into R. The headers from those files are not in good shapes…Nov 19, 2022Nov 19, 2022