我有数百个.xls和.xlsx文件,它们有某种顺序,但相当混乱
通过使用Python/Pandas,我能在不发疯的情况下实现最终结果吗
示例1(文件名:“example1-heephone.xls”):**=bold,在代码块中似乎不起作用
**Features**
**Transmitter**
2.4GHZ
5GHZ
Power LED
- 1 x 3.5mm mic jack
**Receiver**
diameter
impedance
Mic Jack
**Logistic data:**
**Gift Box Measurement**
20'
40'
示例2(“示例2-keyboard.xls”):
**BSCI / SA8000**
BSCI / SA8000 certified
Certificate validity
**Upcost**
**Features**
Display (LCD, or LED)
Sync
**Estimated logistic data:**
Qty
Carton
20'
最终结果应该是一个.xlsx文件,每个列中的值都有一个下拉菜单,如:
|-----------|----------------------|------------------|------------------|-------------------------|-------------------------|
| Article | Transmitter | Receiver | Logistic data: | BSCI / SA8000 | Features |
|-----------|----------------------|------------------|------------------|-------------------------|-------------------------|
| headphone | 2.4GHZ | diameter | 20' | | |
| | 5GHZ | impedance | 40' | | |
| | Power LED | Mic Jack | | | |
| | - 1 x 3.5mm mic jack | | | | |
|-----------|----------------------|------------------|------------------|-------------------------|-------------------------|
| keyboard | | | Qty | BSCI / SA8000 certified | Display (LCD, or LED) |
| | | | Carton | Certificate validity | Sync |
| | | | 20' |
仅适用于.xlsx文件
为了检测样式,可以使用像styleframe这样的外部包。对每个示例文件重复步骤1和2
style
为粗体的索引Example File
必须包含一个额外的头,以减少歧义相关问题 更多 >
编程相关推荐