R Language Learning Notes

R Language Learning setwd("D:\R Language Learning")#Change working path write.table(y, "sample.csv", sep=",")#Save the file > x=scan()#Manual Input 1: 1 2: 2 3: 3 4: 5 5: Read 4 items > x [1] 1 2 3 5 x=scan("a.txt") as.array() as.character() as.data.frame() as. ...

Added by mynameisbob on Fri, 24 Jan 2020 05:27:30 +0200

Python for automatic email, hands free

Using Python to automate email delivery can save you a lot of time by freeing you from tedious, repetitive business. Python has two built-in libraries: smtplib and email, which enable mail, smtplib which sends mail, and email which constructs the format and content of mail. Mail delivery is subject t ...

Added by Bluemercury on Mon, 20 Jan 2020 04:12:38 +0200

In Python, ddt is used to drive data, execute use cases in batches, and modify ddt code

1. What is data-driven? What are the benefits of using data-driven? Use case execution is driven by data. Every test case has the same code except for different test data. In order to use case execution in batch, we will use the idea of data-driven to execute test cases in batch; Benefits: Batch execution of test cases improves the efficiency o ...

Added by reecec on Tue, 07 Jan 2020 00:57:50 +0200

Download Excel file with spring mvc-4.2 + excelview view view

You can download the jar package by yourself, springMvc4.2 + version + poi-3.10.1 version </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.10.1</version> </dependency> <dependency> <groupId>org ...

Added by Volitics on Mon, 06 Jan 2020 12:20:36 +0200

PHPExcel ---- get / import excel file data [simple and practical demo2]

For excel export / save, please refer to another blog post: PHPExcel - save / export excel file data [simple and practical demo] First, you need to have PHPExcel class: Portal Just save the Classes in it. Reference PHPExcel.php in the project First look at the excel data source table you want to obtain: Implementation cod ...

Added by transformationstarts on Wed, 25 Dec 2019 17:10:11 +0200

About Excel, you must use 36 Python functions

From Excel to Python: the most commonly used 36 Pandas functionsAbout Excel, you must use 36 Python functions This paper deals with the 36 most commonly used functions of pandas. Through these functions, it introduces how to complete data generation and import, data cleaning, preprocessing, as well as the most common data classification, data f ...

Added by splitinfo on Mon, 23 Dec 2019 23:28:54 +0200

Climb to the top of Douban movies (score)

First step, we need to crawl the information of Douban, Second, we need to save the information that we crawled down, Next we import the module, Request module of HTTP request and xlwt module of Excel file processing There is also a real time module, we can not crawl too fast, otherwise it will be recognized by the website. impo ...

Added by rashpal on Mon, 23 Dec 2019 23:17:00 +0200

Java converts Excel to PDF based on Spire.Cloud.Excel

Spire.Cloud.Excel SDK Java provides the general API interface and WorkbookApi interface, and supports the conversion of local excel and cloud EXCEL documents to ODS, PDF, XPS, PCL, PS and other formats. This paper introduces the steps and methods of format conversion, taking the conversion of Excel form to PDF as an example. Necessary steps:St ...

Added by Clinger on Wed, 11 Dec 2019 19:42:26 +0200

POI import and export in SpringBoot

2.1 POI overview Official website: http://poi.apache.org/ Can analyze word, ppt, excel Application of POI 1. Export data: backup the data in the database 2. Import data: batch import data from excel into database POI support based on maven coordinate import <!-- excel2003 Package used --> <dependency> <groupId ...

Added by jonners on Tue, 03 Dec 2019 19:10:21 +0200

Java insert attachment to PDF document

Inserting an attachment in a document can serve the purpose of matching with the source document and supplement the document in a more convenient way. The following describes how to insert attachments into PDF documents through Java programming. The document inserted here can be a common document type, such as Word, Excel, Ppt, Txt, or other fi ...

Added by Bladescope on Tue, 03 Dec 2019 04:30:11 +0200