ชื่อและผู้กำกับของภาพยนตร์ใดบ้างที่ไม่เคยถูกนำเสนอในประเทศจีน?
What are the titles and directors of the films were never presented in China?
df_film = pd.DataFrame(columns=['Title', 'Director', 'Film_ID']); df_market = pd.DataFrame(columns=['Market_ID', 'Country']); df_market_estimation = pd.DataFrame(columns=['Market_ID', 'Film_ID'])
df_film[~df_film['Film_ID'].isin(df_market_estimation[df_market_estimation['Market_ID'].isin(df_market[df_market['Country'] == 'China']['Market_ID'])]['Film_ID'])][['Title', 'Director']]