516

Step 1:Data Reading

1. Read social media data Excel file

Step 2:Data Cleaning

1. Handle missing values

2. Remove duplication

Step 3: Data Transformation

1. Sum up the number of likes,commens and shares to create engagement.

2. Rename the new column as engagement.

3. Count the mean for likes by date.

Step 2a: Data Cleaning

Step 4: Data Visualization

1. Line plot for likes (means) by the data.

2. Content type with engagement.

3. Sentiment analysis

4. Relationship between number of followers and followers and engagement.