This is my mysql outside keys stored in the file, how can I after pycharm and mysql connection in pycharm through primary key foreign key index to establish new dataframe,
For example, I want to find out sets of themes associated with color and parts of, how can I will a new dataframe of three columns?

Trouble bosses to help solve, thank!!!!!