import pandas as pd
import numpy as np
from pypinyin import lazy_pinyin
data = pd.read_table(r"C:\...\input.txt", sep = '\t')
data["B"] = data["A"].apply(lambda x : x[4:])
data["C"] = [''.join(lazy_pinyin(_)) for _ in data["B"]]
data = data.sort_values(by = "C")
data