In-depth customs data analysis tools

List of contents of this article:

• 1,In-depth customs data analysis tools May I ask who can write a database query system with python?
• 2, Personal vehicle information query system
• 3, Where can I check the history of temperature and humidity in a place?

Who can write a database query system with python?

In this way, we will realize that SQL, as a query language, is only designed for the structure of two-dimensional data tables. It is very clumsy to use it to query graphs, and soon it will become extremely complex and difficult to expand.

Basically, a python web framework can be written, such as bottle, webpy, etc., and tornado, twisted, etc. with high concurrent performance. For specific examples, you check the data interface of rest style. For example, users use the get method to obtain the html operation interface, and the post method sends the product name, year and month and other information to return to the json query results, etc.

for most software developmentFor example, the term database usually refers to RDBMS (relational database management system). These systems use tables (similar to the grid of spreadsheets), in which the row represents the record and the column represents the field of the record. Tables and the data stored in them are created and manipulated using statements written by SQL (structured query language).

rowcount: This is a read-only attribute and returns the number of rows affected by the execution () method.

personal vehicle information query system

1. The way to query the vehicle under your name is as follows: open and enter the "trafic management" in the mobile phone 12123"; After opening, click the motor vehicle option in the upper left corner of the home page; then you can view the complete vehicle information under the name.

2. Online inquiry: Log in to the local traffic police website, select the motor vehicle information inquiry, and enter the license plate number and engine identification code (large shelf number) after opening the page, and click OK. After the page is opened, all the information of the vehicle is displayed, including the settlement date, annual inspection date, etc.

3. First of all, it is necessary to find a reliable vehicle inquiry system.At present, there are many vehicle inquiry systems on the market, such as vehicle information inquiry of the Ministry of Public Security, traffic management 12123 inquiry, comprehensive inquiry of the vehicle management office, etc.

4. You can also download the 12123 APP, register and log in with your personal ID card, and click the motor vehicle option to query the vehicle under your name. 12123 is the official software of the traffic management department. You can rest assured to inquire without worrying about the leakage of personal information.

5. Log in to the local traffic police network and select motor vehicle information inquiry. After the page opens, enter the license plate number and engine identification code, and click OK. After the page is opened, all the information of the vehicle is displayed, including the settlement date, annual inspection date, etc. If you want to check the violations, it is more convenient.

6. Find the vehicle in the name of the individualIf you want to check the vehicle under your name, you can download the traffic management 12123app, register this app with your mobile phone number and ID card, and enter the home page. There are motor vehicle options. Click in and you can see the car in your name. Another way is to go directly to the DWD with your ID card to inquire.

Where can I check the history of temperature and humidity in a place?

There must be backups in the database of the local weather station, including temperature, humidity, wind, wind direction, rainfall, sunrise and sunset time, etc. Downloading from the official website is only the permission of guest, so you can only see the temperature. You can get some authorization, and then find the local meteorological station data administrator to provide data.

First, open the official website of the National Meteorological Information Center.Secondly, find the ground data, click on the ground data, and find the data and products. Finally, click on the data and product, and check the time, place, temperature and humidity to be queried to query the temperature and humidity data of a quarter.

You can query the historical humidity data through the meteorological data platform. Data source: Xihe Energy Big Data Platform (xihe-energy) Query Step 1: The platform selects the geographical location. You can choose single-point data anywhere in the world or regional average data. Step 2: Confirm the data source.

If you don't need detailed information, check the annual year of a province or a subordinate city. For detailed information, you need to go to the information center under the Meteorological Bureau to ask for money.

Shenzhen's temperature and humidity records from March to April are available at the Shenzhen Meteorological Observatory.Temperature, rainfall and wind speed can be found on the website of Shenzhen Meteorological Bureau.

Market Supervision Bureau. According to Baidu Encyclopedia, the Market Supervision Bureau checks the temperature and humidity records of the factory every year, in order to regularly check the temperature and humidity of the production workshop to ensure that the temperature/humidity of the workshop is within the normal range and the product quality.