30 + program veterans’ Transformation Path — tools (WPS + PostgreSQL)

Time:2021-7-16

Recently, I plan to learn something about data analysis. In the figure below, although there are a lot of advertising elements, there are many techniques. It is said that programmers should have a little product thinking and be sensitive to data.

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)
After reading the introduction of some training institutions, there are many knowledge points involved, including tools, thinking, practice and final report. Sure enough, you can’t be a fat man. Take your time.

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

In the tools, Excel and SQL should be the most basic, but my office license has expired, and I don’t want to crack it. Besides, now the localization is booming, use WPS to see if it can replace it

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Download ODBC driver and download it

First, go to the following link and select psqlodbc_ 11_ 01_ 000.zip Click to download
https://www.postgresql.org/ft…

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Add data source after installation

Open control panel – management tools, select obbc data source (32-bit) and double-click

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Click “add” in the pop-up dialog box and select PostgreSQL Unicode

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Get your database name, service address, user name, port and password

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Fill in the dialog box and click “test” to test the connection. What I am using here is a free cloud database memfiredb. When I prompt “connection successful”, it means the connection is successful. Click “save” to save. Finally, click “OK” to complete all the settings

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Importing data in WPS

Click “data” – “import data”

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)
Select “import data” in the drop-down list. Note that “connect database” is not selected here. Select the ODBC data source configured before, and click “OK” and “next”

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Select the data table name and related fields to import

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Select filter statement

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

preview data

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)

Import data, see the results, then we can call function and drawing in WPS.

30 + program veterans' Transformation Path -- tools (WPS + PostgreSQL)