pip install xpinyin -i http://pypi.douban.com/simple --trusted-host pypi.douban.com

from xpinyin import Pinyin

p = Pinyin()
result1 = p.get_pinyin('叶伏天')
result1

'ye-fu-tian'

result2 = p.get_pinyin('叶伏天', tone_marks='marks')

'yè-fú-tiān'

s = result1.split('-')
result3 = s[0].capitalize() + ' ' + ''.join(s[1:]).capitalize()
result3

结果如下：
'Ye Futian'

# 安装
pip install pypinyin -i http://pypi.douban.com/simple --trusted-host pypi.douban.com

import pypinyin

result1 = pypinyin.pinyin('叶庭云', style=pypinyin.NORMAL)
result1

[['ye'], ['ting'], ['yun']]

result2 = pypinyin.pinyin('叶庭云', heteronym=True)
result2

[['yè', 'xié'], ['tíng'], ['yún']]

result_ = [i[0] for i in result1]
result3 = result_[0].capitalize() + ' ' + ''.join(result_[1:]).capitalize()
result3

'Ye Tingyun'

# 安装
pip install snownlp -i http://pypi.douban.com/simple --trusted-host pypi.douban.com
# 导入
from snownlp import SnowNLP

s = SnowNLP('叶庭云')
s.pinyin

['ye', 'ting', 'yun']

result4 = s.pinyin[0].capitalize() + ' ' + ''.join(s.pinyin[1:]).capitalize()
result4

'Ye Tingyun'

import pypinyin
import pandas as pd

df = pd.read_excel('学生名单_test.xls')
df.head()

pinyin_name = []
first_pinyin = []
for i in df['姓名']:
  result = pypinyin.pinyin(i, style=pypinyin.NORMAL)
  result_ = [i[0] for i in result]
  result2 = result_[0].capitalize() + ' ' + ''.join(result_[1:]).capitalize()
  result3 = ''.join([i[0].upper() for i in result_])
  print(result2, i, sep=' ')
  pinyin_name.append(result2)
  first_pinyin.append(result3)
  
df['英文名'] = pinyin_name
df['拼音首字母'] = first_pinyin
df.head()