[Python] Convert excel file (.xlsx) to json

I have a xlsx file

Country name Country code
IN India
SL Sri Lanka

I want to convert this to a json in the format

json = {
{"Name":"India",
"Code":"IN"},
{"Name":"Sri Lanka",
"Code":"SL"}
}



I tried load the excel file using the pandas and convert them to json but i am getting

json = {
"India":"IN",
"Sri Lanka":"SL"
}

Continue reading...