Pre-Requisites to Understanding this Article
Why should I care about IaaS as a Data Analytics Professional? 🤷
Setting up your DBMS Managed Service using Digital Ocean ⚙️🌊
import psycopg2
import pandas as pd
postgres_connection = psycopg2.connect(
database="machinery_signals",
user="doadmin",
password="wdxeskeZ1QYKJ1tR",
host="db-postgresql-sgp1-74319-do-user-9869967-0.b.db.ondigitalocean.com",
port="25060"
)
try:
print("Trying to connecting to Postgres Database")
print(postgres_connection)
print ("Successful Connection.")
except:
print("Unable to Connect to Postgres Database. Please Check Credentials supplied.")
CREATE TABLE Anomaly_Table_Example \
(\
data_preparation_technique VARCHAR(255),\
attribute VARCHAR(255),\
time TIMESTAMP,\
some_values FLOAT,\
some_anomaly_scores FLOAT,\
anomaly_classification INTEGER \
)