There is a python module called xlsxwriter. After downloading and installing,
import xlswriter

Let’s study how to use it

Then save a traversal dictionary of provinces and counties

pandas modulepivot

The mobile client cannot reply to comments, annoying

Then you have to read a third-party file that has this matching relationship. When reading, just use the province and county as the index and the city as the value

I don’t quite understand what you mean. There is obviously a city and a county, so why match the city? Do you want to get the price?
If you just want vlookup, panda can set the two columns as indexes, and then you can directly get the number based on the index name.