批量生成GF说明xlsx及产品号txt

import os
import pandas as pd


def writefilename2excel(folder_path, excel_path, txt_path):
    # 加载文件夹
    folder = os.listdir(folder_path)
    file_list = []  # 文件名
    satellite_list = []  # 卫星
    sensor_list = []  # 传感器
    longitude_list = []  # 中心经度
    latitude_list = []  # 中心纬度
    time_list = []  # 拍摄时间
    product_ID_list = []  # 产品号
    for file in folder:
        file_list.append(file)
        satellite = file.split('_')[0]
        satellite_list.append(satellite)
        # print(satellite)
        sensor = file.split('_')[1]
        sensor_list.append(sensor)
        longitude = file.split('_')[2]
        longitude_list.append(longitude)
        latitude = file.split('_')[3]
        latitude_list.append(latitude)
        time = file.split('_')[4]
        time_list.append(time)
        product_ID = file.split('_')[5].split('.')[0].split('A')[1]
        product_ID = product_ID.replace(' ', '')
        product_ID_list.append(product_ID)

    all_list = {
        'file_name': file_list,
        'satellite': satellite_list,
        'sensor': sensor_list,
        'longitude': longitude_list,
        'latitude': latitude_list,
        'time': time_list,
        'product_ID': product_ID_list
    }

    df = pd.DataFrame(all_list)
    # columns = ['file_name', 'sensor', 'longitude', 'latitude','time', 'product_ID']
    pd.DataFrame(df).to_excel(excel_path, index=False)

    # for i in range(len(product_ID_list)):
    #     product_ID_list[i].replace("'", "")
    # print(product_ID_list)
    str = ','
    f = open(txt_path, "w")
    f.write(str.join(product_ID_list))
    f.close()


if __name__ == '__main__':
    folder = r'G:\GF\backup'
    excel = r'G:\GF\GFreference.xlsx'
    txt = r'G:\GF\GFreference.txt'
    writefilename2excel(folder, excel, txt)