simple-excel

Simple Excel - Simplified Excel processing

Quick Start

Read Excel file

import pandas as pd

# 读取 xlsx 或 csv
df = pd.read_excel('file.xlsx')
df = pd.read_csv('file.csv')

# 读取指定sheet
df = pd.read_excel('file.xlsx', sheet_name='Sheet1')

Write Excel file

import pandas as pd

Save as xlsx

df.to_excel('output.xlsx', index=False)

Save as csv

df.to_csv('output.csv', index=False)

### 简单数据处理
```python
import pandas as pd

# 筛选数据
df[df['列名'] > 10]

# 添加新列
df['新列'] = df['列1'] + df['列2']

# 分组统计
df.groupby('类别').sum()

# 排序
df.sort_values('金额', ascending=False)

Common Operations

Operation	Code
View the first few rows	df.head()
View data types	df.dtypes
Statistical summary	df.describe()
Select columns	df[['列A', '列B']]
Filter rows	df[df['列'] > 100]
Delete columns	df.drop('列名', axis=1)
Rename columns	df.rename(columns={'旧名': '新名'})
Fill empty values	df.fillna(0)
Export a specified sheet	df.to_excel('file.xlsx', sheet_name='新sheet')

Notes

• Use index=False to avoid exporting the index column
• Chinese characters usually display correctly in Excel
• For large files, it is recommended to use the csv format