Tag: csv

python selenium clicks a series of buttons in the table and outputs the pop-up content to csv

A practical example of python selenium, heavier than the demo, but not too complicated. The trick is summarized as follows: The address of the latest chromedriver is https://googlechromelabs.github.io/chrome-for-testing. This is very important, otherwise you will have to deal with annoying problems such as automatic chrome updates. Many download sources are a bit outdated. Use options […]

Text analysis using python – multi-process batch processing of PDF files into csv files

In the process of text analysis, converting raw data into TXT files is very critical, mainly for the following reasons: 1. Simple and unified format ? A TXT file is a simple text format that contains only plain text information and does not contain any formatting or style information. This simple and unified format helps […]

Go language Json parsing, regular expressions, code examples for exporting CSV files from the database

Json parsing package main import ( “encoding/json” “fmt” “os” ) type MongoConfig struct {<!– –> MongoAddr string MongoPoolLimit int MongoDB string MongoCollection string } type Config struct {<!– –> Port string Mongo MongoConfig } func main() {<!– –> JsonParse := NewJsonStruct() v := Config{<!– –>} if err := JsonParse.Load(“json_parse.json”, & amp;v); err != nil {<!– […]

[PyQt5] Open Excel, CSV, convert tableWidget to dataframe, add options to listWidget, for loop list derivation–list/dict

untitled.py # -*- coding: utf-8 -*- # Form implementation generated from reading ui file ‘untitled.ui’ # # Created by: PyQt5 UI code generator 5.15.9 # # WARNING: Any manual changes made to this file will be lost when pyuic5 is # run again. Do not edit this file unless you know what you are doing. […]

Python operations write/read csv files

Python Data Storage for Network Engineers (Section 1, CSV file) A general process of the evolution of network automation operation and maintenance: network engineers have gradually evolved from focusing on configuration and making scripts, and then brushing the configuration on the device, to network engineers focusing on and determining some important control parameters of device […]

Use POI and JavaCsv tools to read excel files (*.xls, *.xlsx, *.csv) and store them in the MySQL database

First configure maven: import related dependencies 1 <dependency> 2 <groupId>org.apache.poi</groupId> 3 <artifactId>poi</artifactId> 4 <version>3.14</version> 5 </dependency> 6 <dependency> 7 <groupId>org.apache.poi</groupId> 8 <artifactId>poi-ooxml</artifactId> 9 <version>3.14</version> 10 </dependency> 11 <!– https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-schemas –> 12 <dependency> 13 <groupId>org.apache.poi</groupId> 14 <artifactId>poi-ooxml-schemas</artifactId> 15 <version>3.14</version> 16 </dependency> 17 <!– https://mvnrepository.com/artifact/org.apache.xmlbeans/xmlbeans –> 18 <dependency> 19 <groupId>org.apache.xmlbeans</groupId> 20 <artifactId>xmlbeans</artifactId> 21 <version>3.0.0</version> 22 </dependency> 23 […]

Export Qt Tablewidget table data to .csv file in QT

Export and import of Qt Tablewidget table data Preliminary preparation: pro file added QT + = axcontainer Add #include to the header file There is also #include written on the Internet Different versions may have different code writing methods, so test it yourself. 1. Import xls/xlsx file data into TableWidget table We right-click the import […]

Use Python to create a faker instance to generate a csv big data test file and import it into the Hive data warehouse

Article directory 1. Python generates data 1.1 Code description 1.2 Code reference 2. Data migration 2.1 Upload from local machine to server 2.2 Check source data format 2.3 Check size and upload to HDFS 3. Beeline table creation 3.1 Create a test table and import test data 3.2 Create table to display content 4. Processing […]