Python drawing normal curve: linespace combination Matplotlib (put into self write library, one line of code to realize complex drawing)

                    . Not much to say, given mu and sigma, a line of code to achieve complex drawing, all kinds of details of configuration are in silence. PS: the specific usage of this figure is shown ...

Posted on Sun, 23 Feb 2020 04:29:52 -0800 by mega77

On the crawler of Taobao commodity information

Taobao.com is an online shopping website of Alibaba group, founded by Ma Yun on May 10, 2003. It is a C2C shopping website for consumers in mainland China, Hong Kong, Macao, Taiwan and Malaysia. Taobao has some anti climbing methods, which makes people a little confused. After data collection and analys ...

Posted on Sat, 22 Feb 2020 23:16:25 -0800 by aashcool198

Crawling the room number information of douyu - calculating the total number of online viewers

I've been curious about the number of people watching live platforms such as Betta. How many people are there to watch the following Betta today? It's the new coronavirus era. The number of people watching live should not be too small. I hope you can protect yourself and your family and wish you good he ...

Posted on Wed, 19 Feb 2020 19:54:30 -0800 by tecmeister

Java sets Excel adaptive row height and column width

In excel, it is a common method to adjust the overall layout of the table quickly by setting the adaptive row height or column width. When setting the adaption, two situations can be considered: 1. Fixed data, set row height and column width adaptive data (common setting adaptive method) 2. Fix the column width and reduce the data font size to ...

Posted on Tue, 11 Feb 2020 10:18:48 -0800 by jwcsk8r

Encapsulate POI excel export and realize export by configuring xml template

In business system development, business data is usually exported to excel. If only one or two business functions are exported, we can directly write code to realize it. However, if there are many different business data to be exported, if we build workbook s, sheet s, row s and cell s through code, i ...

Posted on Mon, 10 Feb 2020 00:12:56 -0800 by ngu_tri

Python Automation Crawling of Urban Distance [Small Project Required]

Create a database locally, store Excel data in city table, and record all prefecture-level cities and counties, county-level cities and districts of | Hubei Province as sample table data.Using python's xlrd package, define process_data package to store operation excel data, generate classes of sql statements, define op_postgresql package to st ...

Posted on Thu, 06 Feb 2020 19:49:16 -0800 by Right Wing Liberal

POI processes Excel files for export

SXSSFWorkbook is used to generate a large number of Excel data files, the main principle is to generate excel with temporary storage space.POI requires more than 3.8, and the file format requirement generated is 07 and above, because the number of rows of Excel 07 and above is 1048576, which is very large, compared with over 60 ...

Posted on Thu, 06 Feb 2020 08:21:11 -0800 by Comtemplative

Where to store the crawled data

Last time, we took QQ music as an example, mainly learning how to request data with parameters (get request) and the use of Request Headers, and finally crawled to the data of Jay Chou's song information. So here comes a new question: how to save the crawled data? You may come up with a solution: copy a ...

Posted on Thu, 06 Feb 2020 00:24:18 -0800 by grayscale2005.

Order small program, order system, management background batch import excel dishes data

During the period when the ordering system went online, many students gave feedback on whether a batch import function of dishes could be added. Because I am busy at ordinary times, I have no time to add the function of batch import of dishes. Today is just free time, let's teach you to realize the function of batch import of dishes. Later, t ...

Posted on Mon, 03 Feb 2020 03:17:20 -0800 by Spoiler

Python: Crawl daily epidemic data

Preface At present, every major platform, such as Tencent and today's headlines, will update the daily epidemic data, and their data sources are the same, mainly through the health care commission's official network. Taking the whole country, Hubei and Shanghai as examples, there are three websites: T ...

Posted on Sun, 02 Feb 2020 18:41:32 -0800 by maxat