advanced_python_dict.py

```
import csv
import pandas as pd

faculty=pd.read_csv('faculty.csv', index_col=0)
# Q6
faculty_dict={}
for name in faculty.index:    
    if name.split()[-1] not in faculty_dict.keys():    
        faculty_dict[name.split()[-1]]=[[faculty[' degree'][name], faculty[' title'][name], faculty[' email'][name]]]
    else:
       faculty_dict[name.split()[-1]].append([faculty[' degree'][name], faculty[' title'][name], faculty[' email'][name]])  
       
#Q7
for name in faculty.index:
    faculty_dict[tuple(name.split())]=[[faculty[' degree'][name], faculty[' title'][name], faculty[' email'][name]]]
#Q8
for name in faculty.index:
    faculty_dict[(name.rsplit(" ",1)[-1],name.rsplit(" ",1)[0])]=[faculty[' degree'][name], faculty[' title'][name], faculty[' email'][name]]
  
  
  ```