This project involves a comprehensive analysis of Instagram user engagement data. By delving deep into user interactions, content consumption patterns, and audience demographics, the aim is to extract actionable insights. These insights will serve as valuable guidance for various teams including marketing, product development, and user experience.
Python, Pandas, Matplotlib, Jupyter Notebook, Mysql
https://docs.google.com/document/d/1MhN6A-9a36BHkL6UBVaTGYKdNwdXP-Sa/edit
!pip install mysql-connector-python
import mysql.connector # Importing the MySQL Connector library for connecting to MySQL databases
import pandas as pd # Importing the pandas library for data manipulation and analysis
import matplotlib.pyplot as plt # Importing the matplotlib library for data visualization
import warnings # Importing the warnings module to suppress warnings during code execution
from sqlalchemy import create_engine
%load_ext sql
# Suppressing warnings to avoid cluttering the output
warnings.filterwarnings('ignore')A) Marketing Analysis:
-
To identify the five oldest users on Instagram from the provided database.
-
To find the users who have never posted photos on Instagram and encourage them to post.
-
To identify the winner of the contest by determining a user with more likes on a single photo.
-
To Identify and suggest the top 5 most used hashtags on Instagram.
-
To find out on what day of the week most users register on.
B) Investor Analysis:
-
To provide how many times does the average user post on Instagram, also to provide the total number of photos with the total number of users.
-
Determine the users (Potential bots) who have liked every single photo on the site, as this is not typically possible for a normal user.
