Carlo Moro cnmoro

Tested on: Ubuntu 18.04, 20.04

Decide which version of the Oracle client to install
- Each version of the client supports certain versions of the database; for example, Oracle client 12.1 supports Oracle database 10.2 - 19c
- See here for more information: http://support.oracle.com/epmos/faces/DocumentDisplay?id=207303.1
Download the Oracle client packages
- Go here and download the desired RPM package(s): https://www.oracle.com/database/technologies/instant-client/downloads.html

	import uvicorn, asyncio
	import motor.motor_asyncio
	from fastapi import FastAPI
	import pandas as pd

	app = FastAPI()
	client = motor.motor_asyncio.AsyncIOMotorClient()
	db = client['MYDB']

	def process_data(data):

	import category_encoders as ce

	categoric_features = ['a', 'b', 'c']

	woe_encoder = ce.WOEEncoder(cols=categoric_features)
	woe_encoder.fit(X[categorics], y)

	def get_woe_value(feature):
	for map in woe_encoder.ordinal_encoder.mapping:
	if map['col'] == feature:

	# CLUSTERING

	# Davies Bouldin Index -> Menor Melhor para escolha do K

	# Descrição das estatísticas das features
	df.groupby("cluster").describe()

	centroids = kmeans.cluster_centers_
	max = centroids[0]

	import shap
	import numpy as np
	import pandas as pd

	categoric_features = tuple(['FEATURE1', 'FEATURE2', 'ETC'])

	def avaliar_importancias_features(modelo_treinado, X):
	explainer = shap.Explainer(modelo_treinado)
	shap_values = explainer.shap_values(X)

	SERVER-SIDE

	$ sudo apt install wireguard
	$ sudo -i
	$ cd /etc/wireguard/
	$ umask 077; wg genkey \| tee privatekey \| wg pubkey > publickey
	$ cat privatekey
	( Save the key )
	$ cat publickey
	( Save the key )

	sudo apt install nginx (ubuntu)
	sudo yum install nginx (rhel)

	#apache2
	#httpd
	sudo apt install apache2-utils (ubuntu)
	sudo yum install httpd-tools (rhel)

	sudo htpasswd -c /etc/nginx/.htpasswd USUARIO

	sudo dpkg --add-architecture i386
	sudo apt-get install libc6:i386 libncurses5:i386 libstdc++6:i38
	sudo apt-get install multiarch-support libstdc++5:i386 libpam0g:i386
	apt-get install libstdc++5:i386 libpam0g:i386 xterm libstdc++5:i386 libpam0g:i386 libnss3-tools libgtk2.0-0:i386

	pacmd load-module module-null-sink sink_name=Virtual_Sink sink_properties=device.description=Virtual_Sink

	ou

	sudo nano /etc/pulse/default.pa
	add
	load-module module-null-sink sink_name=Virtual_Sink sink_properties=device.description=Virtual_Sink