> lastname,firstname,org,title,phone,email,website,street,city,p_code,country
> Doe,John,John Doe plc,Web Developer,143893456,[email protected],https://johndoe.com, 203 East 50th Steet,New York,10022,USA
> Morgan,Peter,Pythonfactory Inc.,Backend Developer,141996746,[email protected],https://pythonfactory.com,203 Weststeet,New York,10022,USA
import pyqrcode
import pandas as pd
def createQRCode():
df = pd.read_csv("havas.csv")
for index, values in df.iterrows():
lastname = values["lastname"]
firstname = values["firstname"]
title = values["title"]
phone = values["phone"]
email = values["email"]
website = values["website"]
org = values["org"]
street = values["street"]
city = values["city"]
p_code = values["p_code"]
country = values["country"]
data = f'''
"BEGIN:VCARD\n"
"N:{lastname};{firstname};\n"
"FN:{lastname} {firstname}\n"
"TITLE:{title}\n"
"TEL;TYPE=work,VOICE:{phone}\n"
"EMAIL;WORK;INTERNET:{email}\n"
"URL:{website}\n"
"ORG:{org}\n"
"ADR;TYPE=work,PREF;;;{street};{city};{p_code};{country}\n"
"VERSION:3.0\n"
"END:VCARD\n"
'''
image = pyqrcode.create(data)
image.svg(f"{lastname}_{firstname}.svg", scale="5")
createQRCode()
我有一個包含多個員工的 CSV 檔案。我想從這個檔案中為每個員工生成一個 Vcard 二維碼。不幸的是，掃描二維碼時只檢索到 URL。
不幸的是，我不知道該錯誤，因為我對 Python 缺乏經驗。我將非常感謝您的幫助！
uj5u.com熱心網友回復：
當您使用 Python 多行字串時，您也不需要包含換行符、額外的引號和縮進。請嘗試以下操作：
import pyqrcode
import pandas as pd
def createQRCode():
df = pd.read_csv("havas.csv")
for index, values in df.iterrows():
lastname = values["lastname"]
firstname = values["firstname"]
title = values["title"]
phone = values["phone"]
email = values["email"]
website = values["website"]
org = values["org"]
street = values["street"]
city = values["city"]
p_code = values["p_code"]
country = values["country"]
data = f'''BEGIN:VCARD
N:{lastname};{firstname};
FN:{lastname} {firstname}
TITLE:{title}
TEL;TYPE=work,VOICE:{phone}
EMAIL;WORK;INTERNET:{email}
URL:{website}
ORG:{org}
ADR;TYPE=work,PREF;;;{street};{city};{p_code};{country}
VERSION:3.0
END:VCARD'''
image = pyqrcode.create(data)
image.svg(f"{lastname}_{firstname}.svg", scale="5")
createQRCode()
這將創建以下二維碼：
You could do the following to avoid the need for extra variables:
import pyqrcode
import pandas as pd
def createQRCode():
df = pd.read_csv("havas.csv")
for index, v in df.iterrows():
data = f'''BEGIN:VCARD
N:{v['lastname']};{v['firstname']};
FN:{v['lastname']} {v['firstname']}
TITLE:{v['title']}
TEL;TYPE=work,VOICE:{v['phone']}
EMAIL;WORK;INTERNET:{v['email']}
URL:{v['website']}
ORG:{v['org']}
ADR;TYPE=work,PREF;;;{v['street']};{v['city']};{v['p_code']};{v['country']}
VERSION:3.0
END:VCARD'''
image = pyqrcode.create(data)
image.svg(f"{v['lastname']}_{v['firstname']}.svg", scale="5")
createQRCode()
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/352894.html