• Simple data analysis using Python — a case study of hospital sales data analysis

Time：2021-11-23

Data set address of this case (Baidu online disk): link:https://pan.baidu.com/s/1FsEcr3lanXYbYLxGELtJZwExtraction code: 5nvw (this link is permanently valid) Or scan the QR code below to obtain: In this blog, I will use Python data analysis tool to summarize the sales of a hospital in a certain year. Project operation environment: operating system Windows 10 64 bit […]

• The lack of accuracy in calculation caused by MySQL format function

Time：2021-11-8

explain Cause of problem: the MySQL formt function will add a comma to every 3 digits of the numberFor example: a number10000000After formatting with the format function, it becomes10,000,000 Problem description: when a table has an amount column whose money type is decimal (12,5), three decimal places need to be displayed on the page, and […]

• Digital amount to Chinese traditional capital

Time：2021-10-27

Well, I’m writing this. This is my mood. You can test here。 Digital amount to Chinese traditional capital: if (!function_exists(‘rmb_capital’)) { /** *Amount in Chinese words * * @param mixed \$amount * @return string */ function rmb_capital(\$amount) { \$capitalNumbers = [ ‘zero’, ‘one’, ‘two’, ‘three’, ‘four’, ‘five’, ‘six’, ‘seven’, ‘eight’, ‘nine’, ]; \$integerunits = [”, […]

• For example, I want to use angularjs to make a calculator

Time：2021-8-31

I actually want to make an accounting app. There is a box to display the amount from top to bottom, and there are some other options or input boxes. Click the box to display the amount, and the keyboard will pop up at the bottom. The keys are composed of 0-9, decimal point, + – […]

• Four SQL secret skills learned after work

Time：2021-8-5

SQL is a necessary skill for big data practitioners, and most big data technology frameworks also provide SQL solutions. It can be said that SQL is an enduring and new programming language. Especially in the data warehouse field, it is common to use SQL. This article will share four commonly used skills in interview and […]

• Antd form value assignment, react parent-child component value transfer, JS reduce method

Time：2021-6-13

Automatic calculation of contract amount As shown in the figure below. When entering the page, the default value of the contract amount is automatically calculated by the system When there is line information, you need to add up the amount and assign a value to the contract amount Realization idea: 1: Transfer value through props, […]

• [step on the pit series] the long type is used to process the amount, and the scientific counting method causes the amount to be capitalized abnormally

Time：2021-6-9

1. Experience of stepping on the pit Last week, a user reported that a sales order he created could not be opened, but the rest of the sales orders could be opened normally. At that time, he checked the error log of the production environment and found that such an exception was thrown:java.lang.NumberFormatException: For input […]

• Convert number to amount in words

Time：2021-6-9

Convert number to amount in words About more daily use of public class operation method, you can pay attention to the next small website http://www.feiaci.com/#/self/… /** *Convert number to amount in words */ function changeToChinese (Num) { //Judge if the input is not a character, then convert it to a character if(typeof Num == “number”) […]

• Implementation of wechat red packet algorithm with PHP

Time：2021-5-1

Using PHP to send red packets, when we enter the number of red packets and the total amount, PHP will randomly allocate each amount according to these two values to ensure that everyone can get a red packet. The amount of each red packet is different, that is, the amount of red packets should be […]

• The use of SQL server window function over() instead of cursor

Time：2021-4-15

preface: in today’s optimization work, we encountered the problem of slow SQL. We found that many cursors were used to process data before, which led to the need to traverse line by line to calculate the required data in the case of a large amount of data. The result of such processing is that the […]

• Implementation of double mean algorithm and red packet grabbing by golang

Time：2021-3-19

I’m sure you’re not unfamiliar with red packets, but have you ever thought about how to achieve it?First, we need to be clear about the requirements and the constraints of the requirements. There are three main restrictions on red envelopesa. The total amount of the red envelope = the total amount of the red envelope, […]

• Buckle questions 169, 171, 189, 198 and 202

Time：2021-2-22

Buckle questions 169, 171, 189, 198 and 202 169. Most elements code: class Solution { public int majorityElement(int[] nums) { Arrays.sort(nums); return nums[nums.length/2]; } } 171. Serial number of Excel table How to solve the problem: Tag: String traversal, decimal conversion The initialization result is ans = 0. During traversal, each letter is subtracted from […]