It's almost the end of the year , It's time for every company to make a statistical report .
The following is the agent registration company + A case study on the statistics of bookkeeping agency companies .
First of all ：2021 Newly registered company who is the performance Top one
second ：2021 Which enterprises have high taxes in （ notes ： The financial department provides all the data of the company's customers ）
The business department provides 2021 The number of registered companies and service personnel throughout the year
The finance department provides 2021 The tax situation of all enterprises in
All of the above are one Excel form
2 individual Excel The only values in the table that are the same are " Corporate name ", Due to the tax payment information of all customers of the company provided by the finance department , Need to filter out 2021 Tax payment of newly registered enterprises in , Use python Program ---2 individual Excel Table comparative analysis , Find the same business .
Two Excel Table for comparison , Find out what the values of the table are different 
https://blog.csdn.net/itmsn/article/details/121957888?spm=1001.2014.3001.5501 Through the above procedure , find 2021 Tax payment of the enterprise in .
Use 2021 Of a newly incorporated company Excel surface , adopt Pandas Read Excel Table refilter 、 Add up 、 Filter 、 Statistics , Figure out who is the top seller .
It's used here Mito Visual programming software .
jupyterlab And mito Use https://blog.csdn.net/itmsn/article/details/120976442?spm=1001.2014.3001.5501
The requirements can be met through the above operations .
learn Python Almost half a year ,Python Office automation batch processing is very effective in improving work efficiency for repeated complex operations .
