斗笠-pandas处理excel表格

桃扇骨 2023-07-07 11:23 4阅读 0赞

![format_png][]

**斗笠老师是itstar旗下Python学院的高级数据分析师，研究生学历，深耕于it行业五年，有着自己独特的技术风格。****今天带你走进干货小课堂~**

![format_png 1][]

## 一.少量表格的操作 ##

### 1.读取数据 ###

![format_png 2][]

![format_png 3][]

###     ###

### 2.合并数据 ###

![format_png 4][]

###     ###

### 3.生成excel ###

![format_png 5][]

###     ###

### 4.计算数据 ###

![format_png 6][]

![format_png 7][]

![format_png 8][]

##     ##

## 二. 批量处理表格 ##

### 1.批量生成excel表 ###

![format_png 9][]

product=\["海信空调","海尔冰箱","格力空调","海信冰箱","晶弘冰箱","苹果手机","联想电脑","苹果电脑","华为电脑","弘基电脑","小米手机","华为手机","OPPO手机","vivo手机"\]

![format_png 10][]

###     ###

### 2.批量操作excel表 ###

![format_png 11][]

![format_png 12][]

###     ###

### 批量处理excel表格 总结    ###

1.找文件路径 \#os模块  
2.路径+文件名 拼接  
3.读取数据 \#read\_excel()  
4.操作 (例子中是进行100个销售人员,个人总额度的汇总)

——————————————————————————

![format_png 13][]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi9sR2x2b0tIblJVSkZDOThKeWVuWXc3Rmo0d3hUWVBnWGdQeHlOSktLeU9iMjdkNkVzVlJQNHR1S1RicHE2UzlSMG9TNUlCMUs0a3hGVmhtd2hVcm9pY0EvNjQw?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROGZ4bmFsMk9pY2ppYjM5YWgwQ0Q3NGhnSEhkYnRvVGdKU242bUhSZkNOWWlheTVXOXNFamRQTkl2QS82NDA?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROFBma1NhU3MzZXBzaWFRWHFkNTVhYm9TeUYwWXNGWUtDUXlNdEh4REs4RUVzU2M0MkJhaWJlcTh3LzY0MA?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROGc0WUVHeE9IUHFic2U5YkpabXlaRm01RDczZGdMU2VSdEo3aWNVbVV0YmcwRmliSFNkWE5pYXYxZy82NDA?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROGliR2x2NGJnNHIxWlZvYVFmelRScTV5b2VlWVJ2TXIzSVBPcmdRVG1veWszeWxTTTJMdGRBRXcvNjQw?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROE1kWVE0dFliVDRPaWNpYmZyUTRNeVdkYTR1c2prZXFSRHN3ek5LSUZvNmlhbWJERTBVRUY2UGRPZy82NDA?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROHRyRm1pYm05NDdpYVhoWjJHa0oyemhJYWoxUk0yaWM4YVVVWkd5eThGV0xNeEFpY3NKeGhNSzRPT2cvNjQw?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROEE2TFlZbm5mV3R0dGlidklIV0RXZWhYZDA5NmlhMmlheFZLTHRzWUxDazdzVDFNRVpENFREc3NRQS82NDA?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROFdiNmdEaDNxYnRTaWJyaWFudnNCN2ljeDdXazBCY2o3aWNiOGVFeFY3dTFSWmVRUWRmSlNZVDJSbXcvNjQw?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROHZXaWJqdDBzeHhjSGxKV1pCb1NDMGN0UDBVczlkbGJPdFlBUUZnUWtGQTNiU2s2aWNPeHR1OTN3LzY0MA?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROE1RTlg0NGZCdVdtbXppYk1yWWxpYXdoaWJ5OGlidEN2TTcwNFpDTHVoaWN1RHhWZkZwN3pudzhOeTRRLzY0MA?x-oss-process=image/format,png
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROHAzdjA3YVlRbE1WM05kM0RaV1pxS0xFVmd6aWNFUjBKWVU5akxnRDJjRDJVcHNMY21CYVpNWkEvNjQw?x-oss-process=image/format,png
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9sR2x2b0tIblJVTEZ0S053QmQ4RmVtWEhqTlFVUFpROFZ6VTBIaWJaTWd2aFlPWUJuZkQ3UHlvNEpKRk1QMzFyRkR6M1pLZVdwS2NyRndqUnpCeGljR0FBLzY0MA?x-oss-process=image/format,png
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi9sR2x2b0tIblJVSkZDOThKeWVuWXc3Rmo0d3hUWVBnWGFIdG90Z0g1cGliZG5YUWlhTkx2UXVyOHNKa2FieEhUd1hHSEp6Uk1XZjlBbHpLNmRabWVJMkF3LzY0MA?x-oss-process=image/format,png