csv_to_txt.py

import pandas as pd
import os

def csv_to_txt(csv_filename,area_name):
    df = pd.read_csv(csv_filename, encoding='utf-8')
    ips = df.iloc[:, 0]
    download_speeds = df.iloc[:, 5]
    output_filename = csv_filename.replace(".csv", ".txt")
    output_path = os.path.join(output_dir, output_filename)

    with open(output_path, 'w', encoding='utf-8') as f:
        for i, (ip, speed) in enumerate(zip(ips, download_speeds)):
            f.write(f"{ip}#{area_name} {i+1} ↓ {speed}MB/s\n")

output_dir="SpeedTest"
csv_to_txt("HKG.csv","中国香港")
csv_to_txt("KHH.csv","中国台湾")
csv_to_txt("NRT.csv","日本东京")
csv_to_txt("LAX.csv","美国洛杉矶")
csv_to_txt("SEA.csv","美国西雅图")
csv_to_txt("SJC.csv","美国圣何塞")
csv_to_txt("LHR.csv","英国伦敦")