【Python】基础学习&技能提升&代码样例4：常见配置文件和数据文件读写ini、yaml、csv、excel、xml、json

本文链接：https://blog.csdn.net/Code_LT/article/details/140353066

一、配置文件

1.1 ini

config.ini文件如下：

 [url] ; section名称
 baidu = https://www.zalou.cn
 port = 80
 [email]
 sender = ‘[email protected]’

import configparser
# 读取
file = 'config.ini'
# 创建配置文件对象
con = configparser.ConfigParser() 
# 读取文件
con.read(file, encoding='utf-8') 
# 取值， 把con当做嵌套字典来用即可
con["url"]
con["url"]["port"]
# 获取所有section
sections = con.sections() # ['url', 'email']
# 获取特定section
items = con.items('url') # 返回结果为元组 # [('baidu','https://www.zalou.cn'),('port', '80')] # 数字也默认读取为字符串
# 可以通过dict方法转换为字典
items = dict(items)

# 写入
import configparser
config = configparser.ConfigParser()
config['DEFAULT'] = {
   'ServerAliveInterval': '45',
                     'Compression': 'yes',
                     'CompressionLevel': '9'}
config['bitbucket.org'] = {
   }
config['bitbucket.org']['User'] = 'hg'
config['topsecret.server.com'] = {
   }
topsecret = config['topsecret.server.com']
topsecret['Port'] = '50022'     # mutates the parser
topsecret['ForwardX11'] = 'no'  # same here
config['DEFAULT']['ForwardX11']