KarinaC KC2016

People

	# This Python script connects to a PostgreSQL database and utilizes Pandas to obtain data and create a data frame
	# A initialization and configuration file is used to protect the author's login credentials

	import psycopg2
	import pandas as pd

	# Import the 'config' funtion from the config.py file
	from config import config

	# Establish a connection to the database by creating a cursor object

	# Create data from three different multivariate distributions
	X_1 = np.random.multivariate_normal(mean=[4, 0], cov=[[1, 0], [0, 1]], size=75)
	X_2 = np.random.multivariate_normal(mean=[6, 6], cov=[[2, 0], [0, 2]], size=250)
	X_3 = np.random.multivariate_normal(mean=[1, 5], cov=[[1, 0], [0, 2]], size=20)
	df = np.concatenate([X_1, X_2, X_3])

	# Run kmeans
	km = KMeans(n_clusters=3)
	km.fit(df)
	labels = km.predict(df)