Preeya Sawadmanod Preeya0225

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	# Setting up subplots using Pairplot
	# X-columns
	# Y-column
	# Setting up the height of the plot
	g = sns.pairplot(df,
	x_vars=['sepal width (cm)',
	'petal length (cm)'],
	y_vars= 'sepal length (cm)',
	height = 4)

	#Function to plot Scatterplots as subplots
	def subplot_scatter(df, list_of_columns_x, y_col, list_of_titles, list_of_xlabels):
	# Makes sure to have enough rows
	nrows = int(np.ceil(len(list_of_columns_x)/2))

	# Specified figsize, columns and rows
	fig, ax = plt.subplots(nrows=nrows, ncols=2, figsize=(10, 6))

	# Ravel turns a matrix into a vector, which is easier to iterate
	ax = ax.ravel()

	#Import Packages
	import matplotlib.pyplot as plt
	import seaborn as sns
	%matplotlib inline

	#Plotting distribution plot with seaborn
	sns.distplot(df["sepal length (cm)"])

	#Addingt Title with size
	plt.title("Distribution Sepal length", fontsize = 20)

	#Import packages
	import matplotlib.pyplot as plt

	#Specify figuresize
	plt.figure(figsize = (10,10))

	#Plotting a histogram
	plt.hist(df["sepal length (cm)"], color = "pink")

	#Adding Title with size