How to automatically save data in different Excel by using with open statement under Python?

when writing a crawler program, there are multiple contents in the same directory. How to use with open river data to automatically save in different Excel?

for example, I want to use with open to create different tables, such as Beijing .xls; Shanghai .xls; Guangzhou .xls; and so on
, but I can"t implement

at present.

the code is as follows 

global city
for city in ("","",""):
    path=str(r"C:\Users\Batman\Desktop\city.csv")
    with open(path,"a",encoding="ANSI") as f:
        f.close()

but you can only get one city.csv
is there any solution?

Python
Mar.14,2021

just use Excel to open * *. Csv , but you may need to set a delimiter. The easiest thing to do is to separate the column from the column with a space

.

or use xlrd library to modify Excel

.

the pandas library is recommended, which is much more convenient than xlrd or xlwt , and can operate on different data sources with the same interface.

here is an example of ipython 

In [1]: import pandas as pd

In [2]: df = pd.read_csv('a.csv', encoding='utf-8')

In [3]: df
Out[3]: 
      
0    10
1    11
2    12
3    20
4    21
5    22

In [4]: df[df[u''].eq(u'')].to_excel('.xls', encoding='utf-8', index=False)

In [5]: df_gz = pd.read_excel('.xls', encoding='utf-8')

In [6]: df_gz
Out[6]: 
      
0    10
1    11
2    12

Previous: Constructor problem

Next: I found that there will be an inexplicable code in my css?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e9f6aa-46799.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e9f6aa-46799.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?