6 basis of Python data analysis -- batch data analysis

catalogue 7, Using correlation coefficient to judge the correlation of data 1. Using correlation coefficient to judge the correlation of data 2. Find the correlation between a single variable and other variables 8, Variance analysis was used to compare the differences of data 1. Variance analysUTF-8...

Posted by deed02392 on Wed, 02 Jun 2021 04:45:28 +0930

What you don't know about EasyPoi

Easypoi may have been heard of and used by you, but what you want to discuss today is something you really probably don't know?Hope you can learn something new! As for how easypoi is used, it's enough to see people's official documents. EasyPoi The general usage tutorials are not listed here, bUTF-8...

Posted by juxstapose on Sun, 18 Jul 2021 01:35:07 +0930

Data analysis_ excel

1, Overview of data analysis 1. What is data Is sound data? Audio devices can collect sound and convert it into audio digital signals, which can support many interesting applications, such as iphone of siriļ¼ŒSogou's voice input and wechat's voice translation show that in this era where sound caUTF-8...

Posted by Floetic on Tue, 21 Dec 2021 22:41:16 +1030

Java reads Excel templates and dynamically adds data

In project development, we often encounter the demand of report; When you encounter a report, you will inevitably deal with Excel. If you just export the data, I believe most people can solve it, create the file through poi, EasyExcel or other processing tools, and write the data into the file.UTF-8...

Posted by Jas on Tue, 28 Dec 2021 15:51:16 +1030

EasyExcel uses and customizes cell styles

Fixed template method: first create an Excel data column template; Of course, you can also dynamically customize the header in EasyExcel. In fact, they are almost the same In the following case, I use a fixed template to record how to customize the cell style Here is the export method, mainly UTF-8...

Posted by Neotropic on Thu, 30 Dec 2021 12:34:45 +1030

Excel template export + background watermark

1. Template export When you encounter more complex tables, you can think of templates at the first time. Of course, simple tables can also be generated quickly, which can simplify the efficiency of development. We don't have to draw cells one by one, and we need to modify various styles. We canUTF-8...

Posted by Popcorn on Fri, 07 Jan 2022 00:59:58 +1030

Summary of using easyExcel

Summary of using easyExcelBig guy, my programmer Tian. What we bring today is a summary of the simple use of esayExcel, an efficient Excel processing frameworkI received a request from the leader to do an Excel import function, so I gave full play to my specialty - Programming for Baidu.I searcUTF-8...

Posted by Pie on Wed, 26 Jan 2022 21:04:05 +1030

Summary of using easyExcel

Summary of using easyExcel Big guy, my programmer Tian. I received a request from the leader to do an Excel import function, so I gave full play to my specialty - Programming for Baidu. I searched Baidu for a circle of POi import methods, and found a reliable demo. In my opinion, this method isUTF-8...

Posted by moonoo1974 on Fri, 28 Jan 2022 09:33:24 +1030

Automated office: 2. Python automated Excel reading table + style setting

Excel for Python automation Method 1: execute the command with pip Install openpyxl module pip install openpyxl Method 2: in pychar: File - > setting - > Project Interpreter on the left, there is a + in the upper right corner, search openpyxl, and then install package Excel read Read the corresUTF-8...

Posted by funkyres on Sat, 29 Jan 2022 18:17:41 +1030

Introduction to Excel write & read operation in automatic test

Excel write & read operations in automated testing Foregoing In the working process of software test engineer, if you want to get a promotion in salary and technical position, you can't avoid learning and contacting more technologies, not in performance test, security test or automatic test. InUTF-8...

Posted by rocco2004 on Mon, 31 Jan 2022 01:15:06 +1030