import
pandas as pd
list1
=
[
7058
,
7059
,
7075
,
7076
]
list2
=
[
7058
,
7059
,
7012
,
7075
,
7076
,
7034
,
7046
,
7036
,
7015
]
list11
=
[
"Sravan"
,
"Jyothika"
,
"Deepika"
,
"Kyathi"
]
list22
=
[
"Sravan"
,
"Jyothika"
,
"salma"
,
"Deepika"
,
"Kyathi"
,
"meghana"
,
"pranathi"
,
"bhanu"
,
"keshav"
]
dataframe1
=
pd.DataFrame(
{
"Student ID"
: list1,
"Student Name"
: list11})
print
(
'First data frame:'
)
display(dataframe1)
dataframe2
=
pd.DataFrame(
{
"Student ID"
: list2,
"Student Name"
: list22})
print
(
'Second data frame:'
)
display(dataframe2)
mergedf
=
dataframe2.merge(dataframe1, how
=
'inner'
)
print
(
'Merged data frame:'
)
display(mergedf)