-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
598 lines (517 loc) · 42.1 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
863
595
596
597
598
<!DOCTYPE HTML>
<html>
<head>
<title>Melvin J Wallace Portfolio</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
</head>
<body class="is-preload">
<!-- Wrapper -->
<div id="wrapper" class="fade-in">
<!-- Intro -->
<div id="intro">
<h1>Melvin Wallace<br />
Data Analyst</h1>
<p>I am a very meticulous data analyst who is passionate about everything tech and data related. Throughout my
ever learning journey of exploring and finding insights within data, the true enjoyment are the challenges and
processes that are involved in gathering, cleaning, proccessing, analyzing, and visualizing data.
The tools that I use for analyzing and visualizing data vary depending on the project. However, I am
well versed in Excel, MS SQL, MS PowerBI, as well as Python</a>.</p>
<ul class="actions">
</ul>
</div>
<!-- Header -->
<!-- Nav -->
<nav id="nav">
<ul class="links">
<li class="active"><a href="index.html">Projects</a></li>
</ul>
<ul class="icons">
<li><a href="https://www.linkedin.com/in/melvin-j-wallace-546bb6297" class="icon brands alt fa-linkedin"><span class="label">linkedin</span></a></li>
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
</ul>
</nav>
<!-- Main -->
<div id="main">
<!-- Featured Post -->
<article class="post featured">
<header class="major">
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataPyProject.ipynb">Hospital Patient Records Project (Python)<br />
</a></h2>
<p>In this project I will be playing the role of an Analytics Consultant for Massachusetts General Hospital (MGH). I have been asked to build a high-level KPI report for the executive team, based on a subset of patient records.
The purpose of the report is to give stakeholders visibility into the hospital's recent performance, and answer the business questions that the CEO inquired about. The CEO has asked me to summarize any insights that I can derive from the
sample provided. I will be utilizing Python to perform all data analysis in this project.
</p>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataPyProject.ipynb" class="image main"><img src="images/hsopitalpatientrecordspy1.jpg" alt="" /></a>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataPyProject.ipynb" class="button large">View Project</a></li>
</ul>
</article>
<!-- Posts -->
<section class="posts">
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/HospitalPatientRecordsSqlProject.sql">Hospital Patient Records Project (SQL)<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/HospitalPatientRecordsSqlProject.sql"class="image fit"><img src="images/hospitalpatientsrecordssql.webp" alt="" /></a>
<p>I will be playing the role of an Analytics Consultant for Massachusetts General Hospital (MGH). I have been asked to build a high-level KPI report for the executive team, based on a subset of patient records.
The purpose of the report is to give stakeholders visibility into the hospital's recent performance, and answer business questions. The CEO has asked me to summarize any insights that I can derive from the
sample provided. I will be utilizing MS SQL to perform all data analysis in this project.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/HospitalPatientRecordsSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataPyProject.ipynb">Ad Hoc Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataPyProject.ipynb"class="image fit"><img src="images/onlinesalespypic.jpg" alt="" /></a>
<p>In this project I will find trends and patterns to unlock actionable insights. I will utilize the power of Python and its libraries to clean the dataframe by checking for and removing any duplicate rows
of data and null values. Then I will transform the dataframe by extracting the month and the day from the data column to get a more in depth look at the data. I will then process the data by calculating
sums, averages, maximums, and minimum values from the unit sold and unit price columns. Finally, I will answer the business questions about the dataset inquired by the stakeholder.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataSqlProject.sql">Ad Hoc Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataSqlProject.sql"class="image fit"><img src="images/onlinesalessqlpic.jpg" alt="" /></a>
<p>The dataset for this project was retrieved from the Kaggle website and it provides a comprehensive overview of online sales transactions across different product categories. Each row represents
a single transaction with detailed information such as the order ID, date, category, product name, quantity sold, unit price, total price, region, and payment method. In this project I will find
trends and analyze patterns to unlock actionable insights.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/OnlineSalesDataSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/UKTrainRidesPyProject.ipynb">Data Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/UKTrainRidesPyProject.ipynb"class="image fit"><img src="images/uktrainpypic.jpg" alt="" /></a>
<p>The data for this project was retrieved from the website mavenanalytics.io. The data for this project consist of mock train data for a company named National Rail. In this project, I will demonstrate
how to use Python to load a csv file into a dataframe. I will then demonstrate how to inspect the data, checking for correct dtypes, duplicate values, and the count of unique and null values per column.
I will then demonstrate how to extract the month, day, and hour values from the date columns to further enhance my analysis. Lastly, I will move on to answering and creating visualizations to the business
questions inquired by National Rail.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/UKTrainRidesPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/UKTrainRidesSqlProject.sql">Data Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/UKTrainRidesSqlProject.sql"class="image fit"><img src="images/uktrainsqlpic.jpg" alt="" /></a>
<p>This dataset has been retrieved from the mavenanalytics.io webite. The data in this project consist of mock train data for National Rail, a company that provides business services to passenger train
operators in the England, Scotland, and Wales. The data also consist of the time frame for the train trips which is from December of 2023 to April of 2024 and includes details on the type of ticket,
the data and time for each trip, the departure and arrival stations, the ticket price, and more.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/UKTrainRidesSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CRMSalesOpportunitiesPyProject.ipynb">Ad Hoc Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CRMSalesOpportunitiesPyProject.ipynb"class="image fit"><img src="images/crmsopy.jpeg" alt="" /></a>
<p>In this project I will demonstrate how to utilize pandas to import the neccessary libraries for performing analysis and reading in the data to a dataframe. I will then demonstrate how to clean
the data by checking for duplicate, unique, and null values. I will also demonstrate how to perform data transformation by extracting the month value from the date column utilizing pandas
datetime function, which will be used for a more detailed analysis. Lastly, I will demonstrate how to build visualizations for my answers to the given questions utilizing the matplotlib and
seaborn libraries. The data from this project was retrieved from the website mavenanalytics.io. The data consist of a pipeline of business to business sales from a ficticious company that sells
computer hardware, including information on accounts, products, sales teams, and sales opportunities.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CRMSalesOpportunitiesPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CRMSalesOpportunitiesSqlProject.sql">Ad Hoc Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CRMSalesOpportunitiesSqlProject.sql"class="image fit"><img src="images/crmsosql.jpg" alt="" /></a>
<p>The data for this project was retrieved from the website mavenanalytics.io. The data consist of a pipeline of business to business sales from a ficticious company that sells computer hardware,
including information on accounts, products, sales teams, and sales opportunities. In this project I will demonstrate how to import csv files into a created database and how to check the data
for unique, duplicate, and null values. I will then demonstrate how to use functions to extract the month from the date column for more in depth analysis. Finally, I will answer the given
questions associated with this project.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CRMSalesOpportunitiesSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/SpaceMissionPyProject.ipynb">Data Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/SpaceMissionPyProject.ipynb"class="image fit"><img src="images/spacemissionpy.jpg" alt="" /></a>
<p>This dataset has been retrieved from the mavenanalytics.io website. The data consist of all space missions from 1957 to August 2022 and includes the details on the location, date, time, the
and the result of the launch. This data also includes the company responsible, the name, the price, and the status of the rocket used for the mission. In this project I demonstrate how to
use Python to utilize bibraries such as pandas to read a csv file into a dataframe, create a dataframe, manipulate and transform rows and columns in a dataframe, to merge multiple dataframes,
and to extract the year and months from columns for detailed analysis. I also demonstrate how to utilize the matplotlib and seaborn libraries to build and create different visuals in the form
of graphs to tell the story of the data.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/SpaceMissionPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/SpaceMissionSqlProject.sql">Data Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/SpaceMissionSqlProject.sql"class="image fit"><img src="images/spacemissionsql.jpg" alt="" /></a>
<p>This is a dataset taken from the mavenanalytics.io website. The data consist of all space missions from 1957 to August 2022 and includes the details on the location, date, time, the
result of the launch, the company responsible, the name, the price, and the status of the rocket used for the mission. In this project I demonstrate how to utilize SQL to import a csv
file into a relational database, as well as extract, transform, and load data from a relational database.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/SpaceMissionSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CoffeeShopPyProject.ipynb">Ad Hoc Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CoffeeShopPyProject.ipynb"class="image fit"><img src="images/coffeeshoppy1.jpg" alt="" /></a>
<p>This dataset was retrieved from the mavenanalytics.io website. The dataset consist of fictitious transaction records for a fictitious company named Maven Roasters, which operates out
of three different New York City locations. The dataset includes the transaction date, timestamp and location, along with product-level details. I will demonstrate how to load the raw
dataset into a pandas dataframe, how to clean the dataset if neccessary , how to manipulate and transform the dataset to create new columns, how to process the data to perform calculations
on the neccessary columns, and lastly, how to create and build visuals for my findings. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CoffeeShopPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CoffeeShopSqlProject.sql">Ad Hoc Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CoffeeShopSqlProject.sql"class="image fit"><img src="images/coffeeshopsql1.jpg" alt="" /></a>
<p>This is a dataset taken from the mavenanalytics.io website. The dataset consist of fictitious transaction records for a company named Maven Roasters, which operates out of three
different New York City locations. The dataset includes the transaction date, timestamp and location, along with product-level details. I will demonstrate how to load a raw dataset
into a database, how to clean the dataset if neccessary, how to manipulate and transform the dataset to create new columns, how to process the data to perform calculations on the
neccessary columns, and lastly, how to export the dataset into PowerBi for visuals. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/CoffeeShopSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/RestaurantPyProject.ipynb">Data Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/RestaurantPyProject.ipynb"class="image fit"><img src="images/restaurantpy.webp" alt="" /></a>
<p>This dataset is from the mavenanalytics.io website. In this project, I will be analyzing a quarter's worth of orders from a fictitious restaurant serving international cuisisne,
including the date and time of each order, the itmes ordered, and additional details on the type, name, and price of the items. In this project, I will demonstrate how Python can
be used to clean, transform, and create data visuals. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/RestaurantPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/RestaurantSqlProject.sql">Data Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/RestaurantSqlProject.sql"class="image fit"><img src="images/restaurantsql0.jpg" alt="" /></a>
<p>This dataset is from the mavenanalytics.io website. In this project, I will be analyzing a quarter's worth of orders from a fictitious restaurant serving international cuisisne,
including the date and time of each order, the itmes ordered, and additional details on the type, name, and price of the items. In this project, I will demonstrate how SQL can
be used to clean, transform, and manipulate data to answer business questions and find actionable insights. This project is a copy of the above project, however, it is beinig
replicated utilizing SQL. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/RestaurantSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/PizzaPlacePyProject.ipynb">Ad Hoc Analysis with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/PizzaPlacePyProject.ipynb"class="image fit"><img src="images/pizzapypic.jpg" alt="" /></a>
<p>This dataset has been retrieved from the website mavenanalytics.io. The data consist of a year's worth of sales from a ficticious pizza pizza company that includes the date and
time of each order, the type of pizza sold, the size of the pizza, the ingredients, and the quantity. In this project I will demonstrate how to load data into a pandas dataframe,
perform any data cleaning if neccessary for analysis, transform any rows of data to the correct data type, extraction of day and month from the date column to create seperate day
and month columns, processing of data for mathematical calculations, and the creation of various graphs and charts for visualizations. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/PizzaPlacePyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/PizzaPlaceSqlProject.sql">Adhoc Analysis with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/PizzaPlaceSqlProject.sql"class="image fit"><img src="images/pizzasqlpic.jpg" alt="" /></a>
<p>This dataset has been retrieved from the website mavenanalytics.io. The data consist of a year's worth of sales from a fictitious pizza company that include, the date and
time of each order, the type of pizza sold, the size of the pizza, the ingredients, and the quantity. In this project I will demonstrate how to perform any data cleaning
if neccessary for analysis, transform any rows of data to the correct data type, extract the day and month from the date columns, and the processing of data for mathematical
calculations. This project is a copy of the above project, however, it is beinig replicated utilizing SQL. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/PizzaPlaceSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChicagoTrafficCrashesSqlProject.sql">Utilizing Python to Explore, Analyze, and Visualize Data<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChicagoTrafficCrashesSqlProject.sql"class="image fit"><img src="images/chicago_traffic.jpg" alt="" /></a>
<p>Here is a dataset on Chicago traffic crashes and was retrieved from the Kaggle website. This dataset consist of accident related data from the years 2015 through 2023.
In this SQL project, I create code to answer a host of questions. I demonstrate how to data clean by checking for and removing any duplicated rows of data, correcting
any spelling errors and checking for and removing null values. I then demonstrate transformation by extracting information from one column and creating another column
with that information such as time differentials and month columns. Finally, I demonstrate data processing by creating calculated and or calculating columns for values.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChicagoTrafficCrashesSqlProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/TrafficViolationsPy.ipynb">Utilizing Python to Explore, Analyze, and Visualize Data<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/TrafficViolationsPy.ipynb" class="image fit"><img src="images/Traffic-Violations-pic.jpeg" alt="" /></a>
<p>Here is a dataset on traffic violations that was retrieved from the Kaggle website. This dataset has information about the stop date, stop time, driver gender,
driver birth year, driver age, driver race, violation, if there was a search conducted, outcome of the stop, if arrested or not, and if stop was drug related.
In this project, I will analyze this dataset and search for viable information that can help with better understanding the data. In this project I will demonstrate
how to read data into a dataframe utilizing the pandas library, how to use for loops to check all rows in all columns for duplicated, unique and null values, cleaning
data by removing unneccessary columns, dropping null values, removing special characters from values, creating new columns, updating datatypes to correct formats, and
extracting date, month, and year from a datetime column.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/TrafficViolationsPy.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/Real_Estate_Sales_1_Py.ipynb">Utilizing Python to Explore, Analyze, and Visualize Data<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/Real_Estate_Sales_1_Py.ipynb" class="image fit"><img src="images/Real_Estate_Pic.jpg" alt="" /></a>
<p>This dataset was retrieved from the Kaggle website. The name of the dataset is 'Real Estate Sales 2001-2020', and consist of real estate listings and sales from 2001-2021
in the state of Connecticut. The dataset has information on the list year, date recorded, town, address, assessed value, sale amount, sales ratio, property type, residential type,
and years until sold. I will demonstrate how to clean, manipulate, and transform data to answer the questions pertaining to the dataset. After the questions have been answered, I
will then visualize the answers to obtain a clear understanding of the data.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/Real_Estate_Sales_1_Py.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChicagoTrafficCrashesPyProject.ipynb">Data Analysis and Visualization through Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChicagoTrafficCrashesPyProject.ipynb" class="image fit"><img src="images/chicago_car_crashes.jpg" alt="" /></a>
<p>Here is a dataset on Chicago traffic crashes that was retrieved from the Kaggle website. This dataset consist of accident related data from the years 2015 through 2023.
In this Python project, I create code to answer a host of questions. I demonstrate how to data clean by checking for and removing any duplicated rows of data, correcting
any spelling errors and checking for and removing null values. I then demonstrate transformation by extracting information from one column and creating another column
with that information such as time differentials and month columns. I also demonstrate data processing by creating calculated and or calculating columns for values.
Finally, I answer a few questions pertaining to the data as well as create visuals for better understanding the data.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChicagoTrafficCrashesPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/NBA_22_23_Stats_Analysis_SQL.sql">EDA and Answering Questions with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/NBA_22_23_Stats_Analysis_SQL.sql" class="image fit"><img src="images/basketball.jpg" alt="" /></a>
<p>This dataset was retrieved from the Kaggle website. The name of the dataset is 'NBA_22_23_Stats', and consist of NBA stats from the 2022 and 2023 season. The stats that are present
in the dataset are related to points per game, percentages, turnovers, rebounds, games played, and salary. In this SQL project I will be utilizing EDA to gather insights and answer
a host of questions regarding the dataset.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/NBA_22_23_Stats_Analysis_SQL.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/WagesByEduPy.ipynb">EDA and Visualizations with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/WagesByEduPy.ipynb" class="image fit"><img src="images/genderwagepic.jpeg" alt="" /></a>
<p>This personal project is on the difference between gender and race wages based on educational levels. The data consist of average wages of men and women from 1973
until 2022 of the white, black and hispanic race. This dataset was retrieved from the Kaggle website and is open source. In this project I demonstrate
how to process and group numerical data, perform exploratory data analysis to search for trends and insights, and I build charts and graphs to visually
represent the trends throughout the data. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/WagesByEduPy.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/MoviesPython.ipynb">Utilizing Python to Explore, Analyze, and Visualize Data<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/MoviesPython.ipynb" class="image fit"><img src="images/movie_pic.jpeg" alt="" /></a>
<p>In this personal project I will be exploring movie data from the years 2012 to 2016. The data consist of info such as movie title, genre, budget and revenue.
I will be cleaning this data and performing exploratory data analysis to look for trends. I will also perform data processing to calculate an additional 'profits' column
and demonstrate how to represent those findings visually. The dataset was retrieved from the Kaggle website and is open source. </p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/MoviesPython.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/HealthcarePyProject.ipynb">Utilizing Python to Explore, Analyze, and Visualize Data<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/HealthcarePyProject.ipynb" class="image fit"><img src="images/healthcare_pic.webp" alt="" /></a>
<p>This personal project is on a Healthcare Insurance dataset. The dataset was retrieved from the Kaggle website and consists of fictional patient information. In this project I showcase my abilities to clean,
manipulate, transform, process, analyze, and visualize data in a way that provides insight and answers to potential business related questions.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/HealthcarePyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/USRegionalSalesPyProject.ipynb">Exploratory Data Analysis/Data Visualization with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/USRegionalSalesPyProject.ipynb" class="image fit"><img src="images/Regional-Sales-Bar-Graph_full.jpg" alt="" /></a>
<p>In this project I demonstrate the power of different Python libraries such as Numpy for numerical compulations, Pandas for reading in data and data manipulation, as well as Matplotlib and Seaborn for producing visualizations to help understand the data.
The dataset consists of data about US Regional Sales and was retrieved from the Kaggle website.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/USRegionalSalesPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/MiddleEastConflictAnalysis.ipynb">Data Cleaning, Exploration, and Visualization with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/MiddleEastConflictAnalysis.ipynb" class="image fit"><img src="images/israel_palestine_pic.webp" alt="" /></a>
<p>In this Python project, I demonstrate how to clean data, explore data for insights, and visualize data. This dataset was retrieved from the Kaggle website and consists of data related to the casualties on all sides of the Israel and Palestine conflict.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/MiddleEastConflictAnalysis.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ProductPriceSQLProject.sql">EDA and Answering Questions with SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ProductPriceSQLProject.sql" class="image fit"><img src="images/product_price.jpg" alt="" /></a>
<p>This dataset was retrieved from the Kaggle webite and it consist of different fruit and vegetable products from four different retailers based in Atlanta, Chicago, Los Angeles, and New York. The data also has the date, farm price, and the average spread
for the product. In the SQL project, I demonstrate how to transform and manipulate the date column to extract the year and month to create new columns to be used for calculations. I also find the tital and average sales for the different retailers by
month and year. The goal of this project was to answer particular questions and provide insights into the data.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ProductPriceSQLProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChiCrimeExploratoryAnalysisProject.ipynb">Exploring and Visualizing data with Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChiCrimeExploratoryAnalysisProject.ipynb" class="image fit"><img src="images/chicago crime project visual.jpg" alt="" /></a>
<p>In this Python project I explore data to look for insights and trends. I also perform some minor calculations for insights to further understand the data. After that, I begin to visualize the data in ways that
that will easily show correlations and contributing factors. This dataset was retrieved from the Kaggle website and is on the crime statistics in the city of Chicago.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/ChiCrimeExploratoryAnalysisProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/TexasDeathRowProject.sql">Data Cleaning, Transformation, and EDA in SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/TexasDeathRowProject.sql" class="image fit"><img src="images/texas death row project visual.jpg" alt="" /></a>
<p>In this SQL project I clean and transform data, perform EDA, and find insights on the Texas Deathrow dataset found on Kaggles website.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/TexasDeathRowProject.sql" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/VideoGameSalesPyProject.ipynb">EDA in Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/VideoGameSalesPyProject.ipynb" class="image fit"><img src="images/video games sales project visul.jpg" alt="" /></a>
<p>In this python project I perform data cleaning, data transformation, EDA, and data visualization. The data that was used for this project is the Video Game Sales dataset that can be found on the Kaggle website.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/VideoGameSalesPyProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/StudentPerformanceProject.ipynb">EDA and Visualizations in Python<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/StudentPerformanceProject.ipynb" class="image fit"><img src="images/student performance project visual.jpg" alt="" /></a>
<p>In this python project I demonstrate how to clean and manipulate data, how to perform EDA, as well as how to put analysis into beautiful visualizations. The dataset that was used for this
project is a dataset on Student Performance. The data tracks the performance of male and female students in different race/ethnicity groups, across three subjects. This dataset comes off of the Kaggle webite.</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/StudentPerformanceProject.ipynb" class="button">View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/USRegionalSalesProject.sql">EDA in SQL<br />
</a></h2>
</header>
<a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/USRegionalSalesProject.sql" class="image fit"><img src="images/regional sales project visual1.jpg" alt="" /></a>
<p>In this SQL project, I used the US Regional Sales dataset to perform some data cleaning, data processing, as well as some data visualization. In this demonstration I use SQL to calculate percent markup, average, maximum, and minimum values, as well as date differences.
This dataset was retrieved from the Kaggle website.
</p>
<ul class="actions special">
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects/blob/main/USRegionalSalesProject.sql" class="button">View Project</a></li>
</ul>
</article>
</section>
<!-- Footer -->
<section class="split contact">
<section class="alt">
<h3>Location</h3>
<p>Naperville, IL<br />
USA</p>
</section>
<section>
<h3>Phone</h3>
<p><a href="#">(773) 640-6707</a></p>
</section>
<section>
<h3>Email</h3>
<p><a href="#">[email protected]</a></p>
</section>
<section>
<h3>Social</h3>
<ul class="icons alt">
<li><a href="https://www.linkedin.com/in/melvin-j-wallace-546bb6297" class="icon brands alt fa-linkedin"><span class="label">linkedin</span></a></li>
<li><a href="https://github.com/MelvinJWallace/PortfolioProjects" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
</ul>
</section>
</section>
</footer>
<!-- Copyright -->
<div id="copyright">
<ul><li>© Untitled</li><li>Design: <a href="https://html5up.net">HTML5 UP</a></li></ul>
</div>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/jquery.scrollex.min.js"></script>
<script src="assets/js/jquery.scrolly.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>