python文件读写

一般使用

with open('data.json', 'r', encoding='utf_8')as f:
    result = f.read()

with open('data2.json', 'w', encoding='utf_8') as f:
    content = '{"name":"ccb"}'
    f.write(content)

pandas

• 读取csv

import pandas as pd

df = pd.read_csv('example.csv')

• 读取excel

import pandas as pd

df = pd.read_excel('demo.xlsx')

• 读取txt

import pandas as pd

txt_file = "data.txt"
df = pd.read_csv(txt_file, delimiter='\t')

• 写入csv

import pandas as pd

data = [
    {"Name": "Alice", "Age": 30, "City": "New York"},
    {"Name": "Bob", "Age": 35, "City": "Los Angeles"},
    {"Name": "Charlie", "Age": 25, "City": "Chicago"}
]

df = pd.DataFrame(data)
df.to_csv("data.csv", index=False)

• 写入excel

import pandas as pd

data = [
    {"Name": "Alice", "Age": 30, "City": "New York"},
    {"Name": "Bob", "Age": 35, "City": "Los Angeles"},
    {"Name": "Charlie", "Age": 25, "City": "Chicago"}
]

df = pd.DataFrame(data)
df.to_excel("data.xlsx", index=False)

• 写入txt

import pandas as pd

data = [
    {"Name": "Alice", "Age": 30, "City": "New York"},
    {"Name": "Bob", "Age": 35, "City": "Los Angeles"},
    {"Name": "Charlie", "Age": 25, "City": "Chicago"}
]

df = pd.DataFrame(data)
df.to_csv("data.txt", sep='\t', index=False)