KNIME_​project

step 1: data reading

1. read social media excel file

Step 2: Data Cleaning

1.Handle missing value

2.remove duplicates

Sep 3: Data Transformation

1. sum up the numbers of like, comments and share to create engagement.

2. Rename the new column as engagement.

3. Count the mean for like by date

Step 2a: Data cleaning

Step 4: Data Visualization

1.line plot for likes(means) by date

2content type with engagement

3.sentiment analysis

4.Relationship between number of follower and engagement