Instagram Data Analysis using MySQL

Extacting insights from instagram data using MySQL

The code performs the following:

• Create a new database
• Create few tables: users, photos, comments, likes, follows, tags, photo_tags
• Insert a large data set
• Find the 5 oldest users
• Identify inactive users
• Identify the most popular photo (and user who created it)
• Calculate average number of photos per user
• Find the five most popular hashtags
• Finding the bots - the users who have liked every single photo

Authors

Jiangyan Feng - [email protected]

Ph.D. Candidate

Chemical and Bimolecular Engineering

University of Illinois at Urbana-Champaign

200 RAL, 600 S. Mathews Ave., Urbana IL 61801