python 读取txt文件中的josn数据，导入数据库

        txt文本文件能存储各式各样数据，结构化的二维表、半结构化的json，非结构化的纯文本。
存储在excel、csv文件中的二维表，都是可以直接存储在txt文件中的。

        今天因编辑一个微信小程序，学习英语单词用的，需把以前整理的英语单词放入数据库中，特此记录

        

{"hello (hi) ": {"序号": 3295.0, "单词": "hello (hi) ", "音标": "[həˈloʊ]", "词性": "int./n.", "中文": "你好  ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "aah ": {"序号": 3296.0, "单词": "aah ", "音标": "[ɑ]", "词性": "int.", "中文": "啊   ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "ooh ": {"序号": 3297.0, "单词": "ooh ", "音标": "[uː]", "词性": "int.", "中文": "嗬 ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "I ": {"序号": 3298.0, "单词": "I ", "音标": "[aɪ]", "词性": "pron.", "中文": "我     ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "am （I’m = I am）": {"序号": 3299.0, "单词": "am （I’m = I am）", "音标": "[əm]", "词性": "vi.", "中文": "是（我是） ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "goodbye (bye) ": {"序号": 3300.0, "单词": "goodbye (bye) ", "音标": "[ˌɡʊdˈbaɪ] ", "词性": "int./n.", "中文": "再见  ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "How are you": {"序号": 3301.0, "单词": "How are you", "音标": "", "词性": "短语", "中文": "你好么？ 你好！  ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "Woof ": {"序号": 3302.0, "单词": "Woof ", "音标": "[wʊf]", "词性": "int.n.", "中文": "（狗发出的）吠声  ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "no ": {"序号": 3303.0, "单词": "no ", "音标": "[noʊ]", "词性": "int.", "中文": "不，不是   ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "sorry ": {"序号": 3304.0, "单词": "sorry ", "音标": "[ˈsɑːri]", "词性": "adj.", "中文": "对不起   ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "fine ": {"序号": 3305.0, "单词": "fine ", "音标": "[faɪn]", "词性": "adj.", "中文": "（身体）很好的", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "thank ": {"序号": 3306.0, "单词": "thank ", "音标": "[θæŋk] ", "词性": "v.", "中文": "谢谢  ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "you ": {"序号": 3307.0, "单词": "you ", "音标": "[jə]", "词性": "pron.", "中文": "你 ", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "Thank you": {"序号": 3308.0, "单词": "Thank you", "音标": "", "词性": "短语", "中文": "谢谢你", "单元": 1.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}, "what": {"序号": 3309.0, "单词": "what", "音标": "[wɑːt] ", "词性": "pron.", "中文": "什么 ", "单元": 2.0, "年级": "一年级上册", "ls": [], "hxy": 0, "hxe": 0, "yxy": 0, "yxe": 0, "txy": 0, "txe": 0, "wry": 0, "wre": 0}｝

这是帮载取的一点，便于朋友试验。

下面上代码

# _*_ coding: UTF-8 _*_
# 开发团队： 迅之达
# 开发人员： Administrator
# 开发时间：2021/8/8 7:22
# 文件名称： txt-json-shjk.py
# 开发工具: PyCharm

import pandas as pd
import json

f = open("./data/english10.txt","r",encoding="utf-8")

data = json.load(f)

print(data)
for dc in data:
    print(dc)
    print(data[dc])

效果：

 

# _*_ coding: UTF-8 _*_
# 开发团队： 
# 开发人员： Administrator
# 开发时间：2021/8/8 7:22
# 文件名称： txt-json-shjk.py
# 开发工具: PyCharm

import pandas as pd
import json

f = open("./data/english10.txt","r",encoding="utf-8")

data = json.load(f)

print(data)
for dc in data:
    print(dc)
    print(data[dc]['单词'])

 效果

 

 数据拿到，存入数据库就不写了，想看软件效果的，可搜微信小程序“易学习英语",如家中有学生的，建意试试，对记单词应很有帮助的。

 

 估计今明两天会上线