MainAnalysis.py

sql_query = """
            SELECT main_user.id, age, gender, race, height, weight, drinks, tobacco, illegal_drugs, 
                   prescription_drugs, network_size, likes, media, follows, followed_by, comments 
            FROM main_user
            JOIN main_survey ON main_user.id = main_survey.id 
            JOIN (
                select 
                    sum(likes) as likes, 
                    sum(comments) as comments,
                    survey_id as id 
                from 
                    main_instagrammedia 
                group by 
                    survey_id
            ) media_totals 
            ON main_survey.id = media_totals.id;
            """

arradata = pd.read_sql(sql_query, engine)