用python分析英语元音及辅音音素在单词中的出现频率数据

 

 

import sqlite3
import matplotlib.pyplot as plt


vowels=["iː","i","ɪ","e","æ","ɑː","ɒ","ɔː","ʊ","u","uː","ʌ","ɜː","ə","eɪ","əʊ","aɪ","aʊ","ɔɪ","ɪə","eə","ʊə"]

consonants=["p","b","t","d","k","ɡ","tʃ","dʒ","f","v","θ","ð","s","z","ʃ","ʒ","h","m","n","ŋ","l","r","j","w"]



conn=sqlite3.connect(r"d:\englishwords.db")
cursor=conn.cursor()

sql="SELECT * FROM englishwords"
cursor.execute(sql)
result=cursor.f