Python tutorial 95 -- Summary of Python knowledge points of Excel operation

One 、 demand ：

1、Excel Preprocessing

Get excel in the future , First fill the empty cells with 0.

2、 Read excel form

Use pandas Read excel surface

3、 Two excel Merge

Finished reading Excel surface merge function , Merge 2 individual Excel Table is a table .

4、 export Excel form

Two 、 development environment ：

Mac、jupyter lab

3、 ... and 、 Code program

 
After the above operation , Use pandas Yes excel You can achieve the desired goal .

If individual developers can start from beginning to end , Complete all manual code tapping .

explain python Yes excel Proficiency in operation , It has changed from basic to advanced .