ค้นหาชื่อแผนกและห้องของหลักสูตร INTRODUCTION TO COMPUTER SCIENCE
Find the department name and room of the course INTRODUCTION TO COMPUTER SCIENCE.
df1 = pd.DataFrame(columns=['DNO', 'CName']); df2 = pd.DataFrame(columns=['Dname', 'Room', 'DNO'])
df1.merge(df2, on='DNO')[df1['CName'] == 'INTRODUCTION TO COMPUTER SCIENCE'][['Dname', 'Room']]