問題拆解:
1.如何讀取csv?
2.如何按對應(yīng)信息發(fā)送到微信?
代碼展示:
import csv
from wxpy import *
import time
def read_info():
f = open('./sample.csv','r')
#讀取成字典型數(shù)據(jù)
reader = csv.DictReader(f)
#使用列表解析式
return [info for info in reader]
def make_msg(raw_info):
t = '{n}同學(xué)請于{t}時(shí)間參加{s}課程痊夭,課程地址是{a}虹曙。收到請回復(fù)矾踱,謝謝!'
return [t.format(n=info['姓名'],t=info['上課時(shí)間'],s=info['課程'],a=info['上課地址']) for info in raw_info]
def send(msg_list):
bot =Bot()
for msg in msg_list:
fren_name = msg.split('_')[0]
f = bot.friends().search(fren_name) #list
if len(f) == 1:
f[0].send()
else:
print(fren_name)
print('Please check this name')
time.sleep(3)
raw_info = read_info()
msg = make_msg(raw_info)
send(msg_list)