[python data analysis (11)] Pandas for text data processing (string judgment, data processing at both ends, replacement and segmentation, basic index)

1. Pandas for text data processing 1) Pandas is equipped with a set of methods for strings, which makes it easy to operate on each element of the array; 2) Access through str and automatically exclude missing / NA values, 3) For example, the method of. str.contains() in membership judgment was mention ...

Posted by MilesStandish on Tue, 25 Feb 2020 22:41:25 -0800

Minecraft Fabric Client tutorial 2 modifying file and directory names to add run and stop

First appeared in Enaium's personal blog Modify package name, json file, add run stop First, modify the package name Change ExampleMod.java to ExcelInitializer.java Modify the JSON files modid.mixins.json and fabric.mod.json Change modid.mixins.json to excel.mixins.json Contents of excel.mixins.json: { "required": true, "package": "cn.e ...

Posted by stone.cold.steve.austin on Sat, 22 Feb 2020 07:53:24 -0800

Java add, read and delete Excel document properties

In document properties, you can set many information about the document, such as creation time, author, company, category, keywords, notes and other summary information, as well as some custom document properties. Next, we will use Java program to demonstrate how to set it. At the same time, we can a ...

Posted by pmaiorana on Thu, 20 Feb 2020 23:17:31 -0800

python automatically sends results to enterprise wechat

With the progress of science and technology, more and more people feel that python is powerful and lucky, especially some automatic detection, etc., which automates some mechanized work, and finally sends the results to wechat or email. If you are too lazy to read wechat or email, you can call to inf ...

Posted by rubenc on Wed, 19 Feb 2020 06:18:05 -0800

EXCEL password clearing (password protection and cracking) - clever use of macro code

All of you have experienced the password setting in excel. After a long time, I thought I would never forget the password in my life. I really forgot it. The only thing we can do is crack, but all kinds of crack tools on the Internet are not reliable, all kinds of worries, we finally got up the cour ...

Posted by trent2800 on Tue, 18 Feb 2020 00:31:42 -0800

layui multiple file upload buttons for one page

Project background Recently, in the UAV mission distribution module, there is a business scenario where you need to add specific path points to each flight path. Here, you choose to add them directly by importing the excel table. The path point information has been set in the excel table in advance. ...

Posted by janderson on Mon, 17 Feb 2020 21:52:36 -0800

Python merging multiple Excel data

Installation module 1. Find the corresponding module http://www.python-excel.org/ 2. Install with pip install pip install xlrdpip install XlsxWriter pip list view XlsxWriter example 1 import xlsxwriter 2 3 # Create a workbook and add a worksheet 4 workbook = xlsxwriter.Workbook("demo.xlsx") 5 worksheet = workbook.add ...

Posted by strudo on Thu, 13 Feb 2020 10:23:09 -0800

UIPath RPA Developer Advance Certificate of Completion

Certification training fee At present, all courses and certifications of the official college are free of charge. The official website says that fees will be charged after March 2020 Links used in the authentication process 1.uipath Certification Center: https://certificate.uipath.com You need to re ...

Posted by jd307 on Wed, 12 Feb 2020 04:35:23 -0800

Java encrypt / decrypt Excel

Summary When setting excel file protection, you can usually choose to encrypt and protect the entire workbook, and you need to enter a password when opening the file; or you can encrypt the specified worksheet, that is, you can set the content of the table to read-only, and you cannot edit the worksheet. In addition, you can also set protection ...

Posted by slick101 on Fri, 07 Feb 2020 01:45:26 -0800

File System (01): Manage Excel and PDF file types based on the SpringBoot framework

Source code for this article: GitHub. Click here || GitEE. Click here 1. Introduction to Document Types 1. Excel Documents Excel is a spreadsheet software.Intuitive interfaces, excellent computing functions and chart tools are often used in system development to transfer data to Excel files or to import Excel data into the system, which involve ...

Posted by Round on Thu, 06 Feb 2020 18:54:39 -0800