ETL Pipeline Exercise: Transform

To continue our pipeline implementation, we’ll now focus on transforming the extracted data. According to the business requirements and the schema of the data warehouse, there are a few issues we need to fix with our extracted data. They are:

1. To change the month format of all date columns from numerical to text (for example, from 08 to Aug)

2. To remove tabs and new lines from columns comment_text and post_text

3. To bin the number of followers into three categories, low, medium, high (the number of followers lower than 1000 will be in low category, the number of followers ...