😉

Spaak NGOMA 5Spaak

😉

Data Analyst Student ! Passionate about Data and all around it. I love learning news skills and share if I have understood correctly too.

5Spaak / medical5.py

Created July 6, 2023 17:33

	# Import plotly libraiy and "%matplotlib inline" is to fix charts in proper manner in the jupyter lab
	import plotly.express as px
	%matplotlib inline


	# We fix all configurations concern our visuals
	sns.set_style('darkgrid')
	matplotlib.rcParams['font.size']=14
	matplotlib.rcParams['figure.figsize']=(200,45)
	matplotlib.rcParams['figure.facecolor']='#00000000'

5Spaak / medical4.py

Created July 6, 2023 17:28

	# To get the statistical summary of the data
	medical_df.describe()

5Spaak / medical3.py

Created July 6, 2023 17:21

	# To get information about our dataset
	medical_df.info()

5Spaak / medical2.py

Created July 6, 2023 17:19

	# To display the top 5 rows
	medical_df.head(5)

5Spaak / medical1.py

Created July 6, 2023 17:04

	# The link of our dataset
	medical_charges_url = 'https://raw.githubusercontent.com/JovianML/opendatasets/master/data/medical-charges.csv'

	# The urlretrieve function to put data in 'medical.csv' format
	urlretrieve(medical_charges_url, 'medical.csv')

	# Here, we're using pd.read_csv function to pull or read our data
	medical_df = pd.read_csv('medical.csv')

5Spaak / medical.py

Created July 6, 2023 17:00

	import pandas as pd
	import numpy as np
	import matplotlib
	import matplotlib.pyplot as plt
	import seaborn as sns
	from urllib.request import urlretrieve

5Spaak / sqlAlias.sql

Created June 23, 2023 23:00

5Spaak / sqlCase1.sql

Created June 23, 2023 22:19

	SELECT st.name,
	st.percentage,
	IF(st.percentage >= 35, 'Pass', 'Fail') AS `Remark`
	FROM student AS st ;

5Spaak / sqlCase.sql

Created June 23, 2023 22:12

	SELECT st.name,
	st.percentage,
	CASE WHEN st.percentage >= 35 THEN 'Pass' ELSE 'Fail' END AS `Remark`
	FROM student AS st ;

5Spaak / sqllike7.sql

Created June 22, 2023 10:03

SELECT * FROM customers WHERE name LIKE '%son%';