About the Skill Path Projects category

Hi everybody, I just finish my first skill path project in the Analyze Data with SQL skill path.
I made a powerpoint presentation for present the results of the analyisis using the template that Codeacademy provided me.
The project name is “Usage Funnels with Warby Parker” and it basically analysis the data of a sales funnel discovering insights from the data recopiled. I also adjunt the rubric for you could be able to score my work.
Sorry if my grammar isn’t correct sometimes because english is not my first language.

powerpoint presentation link:

rubric link:

Hello coders, I just finish the “Marketing Attribution” project in “Analyze Data with SQL” skill path.
I made a powerpoint presentation to answer the questions and present the insights I found.
I will be glad if you give me feedback about my work, Thanks!!

Just Finished Building a website with HTML CSS and GitHub page and here is my Git hub reposotory


Bank teller project finished the code is below.

checking_balance = 0
savings_balance = 0
def check_balance(account_type, checking_balance, savings_balance):
if account_type == “savings”:
balance = savings_balance
elif account_type == “checking”:
balance = checking_balance
print(“Unsuccessful, please enter checking or savings”)
balance_statement = "Your " + account_type + " balance is " + str(balance)
return balance_statement
print(check_balance(“checking”, checking_balance, savings_balance))
print(check_balance(“savings”, checking_balance, savings_balance))
def make_deposit(account_type, amount, checking_balance, savings_balance):
deposit_status = “”
if amount > 0:
if account_type == “savings”:
savings_balance += amount
deposit_status = “successful”
elif account_type == “checking”:
checking_balance += amount
deposit_status = “successful”
deposit_status = “Unsuccessful, please enter checking or savings”
deposit_status =“unsuccessful, please enter an amount greater than 0”

deposit_statement = "Deposit of " + str(amount) + " to your " + account_type + " account was " + deposit_status + "."


return savings_balance, checking_balance

savings_balance, checking_balance = make_deposit(“savings”, 10, checking_balance, savings_balance)
print(check_balance(“savings”, checking_balance, savings_balance))
savings_balance, checking_balance = make_deposit(“checking”, 200, checking_balance, savings_balance)
print(check_balance(“checking”, checking_balance, savings_balance))
def make_withdrawal(account_type,amount,checking_balance,savings_balance):
withdrawal_status = “”
fail = “unsuccessful, please enter amount less than balance”
if account_type == “savings”:
if savings_balance >= amount:
saving_balance -= amount
withdrawal_status = “successful”
withdrawal_status = fail
elif account_type == “checking”:
if checking_balance >= amount:
checking_balance -= amount
withdrawal_status = “successful”
withdrawal_status = fail
withdrawal_status = “unsuccessful, please enter checking or savings”
withdrawal_statement = "Withdrawal of " + str(amount) + " from your " + account_type + " was " + withdrawal_status + “.”
return savings_balance, checking_balance
savings_balance, checking_balance = make_withdrawal(“savings”,11,checking_balance,savings_balance)
savings_balance, checking_balance = make_withdrawal(“checking”,170,checking_balance, savings_balance)
print(check_balance(“checking”,checking_balance, savings_balance))
def acc_transfer(acc_from,acc_to,amount,checking_balance,savings_balance):
transaction_status = “”
trans_error = “unsuccessful, please enter amount less than”
if acc_from == “savings” and acc_to == “checking” :
if savings_balance >= amount:
savings_balance -= amount
checking_balance += amount
transaction_status = “successful”
transaction_status = trans_error + str(savings_balance)
elif acc_from == “checking” and acc_to == “savings”:
if checking_balance >= amount:
checking_balance -= amount
savings_balance += amount
transactions_status = “successful”
transaction_status = trans_error + str(checking_balance)
transaction_status = “unsuccessful, please enter checking or savings”
transaction_status = "Transfer of " + str(amount) + " from your " + acc_from + " to your " + acc_to + " account was " + transaction_status + “.”
return savings_balance, checking_balance
savings_balance, checking_balance = acc_transfer(“checking”,“savings”,40,checking_balance,savings_balance)
print(check_balance(“savings”,checking_balance, savings_balance))
savings_balance, checking_balance = acc_transfer(“savings”,“checking”,5,checking_balance,savings_balance)

Please find below the code for the finished real_estate_investment_trust project. I have attached the file as well
import numpy as np
SBRA = np.genfromtxt(‘SBRA.csv’, delimiter = ‘,’, skip_header = 1, usecols =5)
EQR = np.genfromtxt(‘EQR.csv’, delimiter =‘,’, skip_header = 1, usecols =5)
def rate_of_return(adj_closing):
daily_simple_ror = np.diff(adj_closing)
return daily_simple_ror
average_daily_simple_return_sbra = np.mean(rate_of_return(SBRA))
average_daily_simple_return_sbra = np.mean(rate_of_return(EQR))

def log_returns(adj_closings):
log_adj_closings = np.log(adj_closings)
daily_log_returns = np.diff(log_adj_closings)
return daily_log_returns

daily_log_returns_sbra = log_returns(SBRA)
daily_log_returns_eqr = log_returns(EQR)
def annualize_log_returns(daily_log_returns):
average_daily_log_returns = np.mean(daily_log_returns)
annualized_log_returns = average_daily_log_returns * 250
return annualized_log_returns
annualized_log_return_sbra = annualize_log_returns(daily_log_returns_sbra)
annualized_log_return_eqr = annualize_log_returns(daily_log_returns_eqr)
daily_variance_sbra = np.var(daily_log_returns_sbra)
daily_variance_eqr = np.var(daily_log_returns_eqr)
daily_sd_sbra = np.std(daily_log_returns_sbra)
daily_sd_eqr = np.std(daily_log_returns_eqr)
corr_sbra_eqr = np.corrcoef(daily_log_returns_sbra, daily_log_returns_eqr)

thank you

This is the code for the visualizing_tech_stokcs project. The changes had to be done for the yahoo finance DataReader because the command in the instruction file to read data from yahoo finance is not working. a new solution is used yfinance.
import numpy as np
from datetime import datetime
import matplotlib.pyplot as plt

symbols = [‘MSFT’,‘AMZN’,‘AAPL’,‘GOOG’,‘META’]
start_date = datetime(2019,1,1)
end_date = datetime(2019,7,1)
stock_data = yf.download(symbols, start = start_date, end = end_date)

stock_data_adj_close = stock_data[‘Adj Close’]

plt.xlabel(“Date Daily”)
plt.ylabel(“Adjusted Closing Price Over Time”)
plt.title(“Tech Stocks Adjusted Price”)

stock_data_returns = stock_data_adj_close.pct_change()
plt.xlabel(“Date Daily”)
plt.ylabel(“Stocks Returns”)
plt.title(“Tech stocks returns”)
#5subplots of daily returns of the stocks
MSFT = stock_data_returns[‘MSFT’]
AMZN = stock_data_returns[‘AMZN’]
AAPL = stock_data_returns[‘AAPL’]
GOOG = stock_data_returns[‘GOOG’]
META = stock_data_returns[‘META’]

fig = plt.figure(figsize=(15,15))
ax1 = fig.add_subplot(3,2,1)
ax2 = fig.add_subplot(3,2,2)
ax3 = fig.add_subplot(3,2,3)
ax4 = fig.add_subplot(3,2,4)
ax5 = fig.add_subplot(3,2,5)

#mean returns
stock_data_mean_returns = stock_data_returns.mean()
plt.ylabel(“Mean Return”)
plt.title(“Stocks Mean Returns”)

stock_data_returns_varinace = stock_data_returns.var()
plt.title(“Daily Variance”)
stock_data_returns_stdv = stock_data_returns.std()
plt.ylabel(“Standard Deviation”)
plt.title(“Daily Standard Deviation”)
stock_data_returns_corr = stock_data_returns.corr()


thank you

Here is my code for the ‘Build Chatbots with Python’ capstone project:


The attached link is for my Orion Constellation Data Visualization in Python project I did. I’m not if attaching a link to the jupyter works. If not, please let me know of any other ways I can submit for feedback.


Good afternoon everyone and Happy Memorial Day!

I just completed my first Practice Project - Fashion Blog. I added a few additional code such as background color and a clickable e-mail hyperlink. I did run the code through a code validator, and got this error message:

div error

I can’t seem to figure out what I should do differently, but I am open to suggestions to what I could do better overall.

<!DOCTYPE html>
<html lang="en">
	<meta charset="UTF-8">
	<title>Everyday with Isa</title>
<body style="background-color:#D6B693;">
  <!--Added neutral background to give blog some color -->
  <a href="#contact"> <img src="https://content.codecademy.com/courses/learn-html/elements-and-structure/profile.jpg" alt="Profile photo of Isabelle Rodriguez"></a>
  <h3>by Isabelle Rodriguez | 1 day ago</h3>
<h1>An Insider's Guide to NYFW</h1>
  <img src="https://content.codecademy.com/courses/learn-html/elements-and-structure/image-one.jpeg" alt="Model holding shopping bags">
  <p><a target="_blank" href="https://en.wikipedia.org/wiki/New_York_Fashion_Week"> NYFW</a> can be both amazingly fun & incredibly overwhelming, especially if you’ve never been. Luckily, I’m here to give you an insider’s guide and make your first show a pleasurable experience. By taking my tips and tricks, and following your gut, you’ll have an unforgettable experience! 
<h2>Getting Tickets & Picking the Shows</h2>
  <img src="https://content.codecademy.com/courses/learn-html/elements-and-structure/image-two.jpeg" alt="Model wearing a nude garment with a black leather jacket over it sporting an expensive watch">
  <p>If you’re lucky or connected you can get an invite, sans the price tag. But I wasn’t so lucky or connected my first 2 years so I’m here to help you out. First, plan out which shows are most important to you and make a schedule and this is a biggie: SET A BUDGET. If you’re worrying about blowing your cash the whole time you won’t have fun. Then check out prices, days, and times and prioritize the designers you want to see most. Lastly, purchase your tickets and get excited!
<h2>Dressing for the Shows</h2>
  <img src="https://content.codecademy.com/courses/learn-html/elements-and-structure/image-three.jpeg" alt="African-American male model modeling in front of building">
  <p>Always be true to your own sense of style, if you don’t you’ll be uncomfortable the whole time and it will show. Remember, NYFW is about expressing yourself and taking in what the designers have chosen to express through their new lines. Also it’s important to wear shoes you’ll be comfortable in all day. Obviously you want to look good, but you’ll be on your feet all day long, so be prepared.
<h4>Related Content</h4>
      How To Style Boyfriend Jeans
      When Print Is Too Much
      The Overalls Trend
      Fall's It Color: Blush
<div id="contact">
  <!-- added clickable e-mail hyperlink -->
  <p><strong>email: <a href="mailto:[email protected]">[email protected]</a> | phone: 917-555-1098 | address: 371 284th St, New York, NY, 10001</strong></p>

Please, I’ve had over 5 projects on my ‘Full stack Engineering’ skill path.
I’m not really sure of how to share this project for your reviews.

Do i just copy and paste the codes here, or send the files as they are?
I could compress all files too, as I would really like people’s opinion on what I’ve achieved so far, even though I’m not yet stuck at any point.



OBJECTIVE: To provide an overview of basic principles related to airplanes and the science of flight.


  • Aerodynamics: The study of how air moves around objects, including airplanes, and the forces that affect their flight. When an airplane flies, its design is carefully engineered to manipulate the flow of air around it. The shape of the wings, the curvature of the airfoil, and other factors determine how an airplane generates lift.

  • Four Forces of Flight:

    1. Lift: The upward force that keeps an airplane in the air. It is generated by the shape of the wings and the angle at which they meet the oncoming air. Lift counteracts the force of gravity, allowing the airplane to stay aloft.

    2. Thrust: The the forward force that propels an airplane through the air. It is produced by engines (like jet engines or propellers) and is essential for maintaining speed and overcoming drag.

    3. Drag: The resistance an airplane encounters as it moves through the air. It’s caused by air friction and the airplane’s shape. Pilots and engineers work to minimize drag to increase fuel efficiency and speed.

    4. Gravity: The force that pulls everything toward the Earth. To fly, an airplane must generate enough lift to overcome the force of gravity.

  • Parts of an Airplane:
    Airplanes are complex machines with several essential components:

    1. Wings: The primary lifting surfaces of an airplane. The shape of the wings is crucial for generating lift.

    2. Fuselage: The body of the airplane and houses passengers, cargo, and flight instruments.

    3. Tail: Includes the vertical stabilizer (fin) and horizontal stabilizer (elevator). These components help control the airplane’s stability and direction.

    4. Engines: Provide thrust needed to move the airplane forward. There are various types of engines, such as jet engines and propellers.

There are two to build our plane:
1. Balsa Wood Glider:

		Materials Needed (estimated cost):

			- Balsa wood sheets (around $10 USD)
			- Craft knife or X-Acto knife (around $5 USD)
			- Sandpaper (various grits, around $5 USD)
			- White glue (around $3 USD)
			- Ruler (around $2 USD)
			- Pencil (around $1 USD)
			- Acrylic paints and brushes (around $10 USD)
			- Masking tape (around $2 USD)
			Total: $38 USD
			Optional: small plastic wheels (around $2 USD)


			- Provide students with templates or encourage them to design their own glider shapes on paper.
			- Use the craft knife to carefully cut out the glider components from balsa wood, including wings, tail, and fuselage.
			- Sand the edges and surfaces of the balsa wood pieces to ensure they are smooth.
			- Assemble the glider using white glue. Let it dry according to the glue's instructions.
			- Paint and decorate the glider as desired.
			- Attach small plastic wheels to the fuselage for a landing gear (optional)
			- Test the glider's flight capabilities in an open area.

	2. Straw and Paper Airplane:
		Materials Needed (estimated cost):

			- Plastic drinking straws (around $2 USD)
			- Sheets of paper (around $5 USD)
			- Scotch tape (around $2 USD)
			- Scissors (around $2 USD)
			- Markers or colored pencils (around $5 USD)
			- Ruler (around $2 USD)
			Total: $18 USD
			Optional: stickers or decorative materials (around $5 USD)	


		- Show students different paper airplane designs (e.g., dart, glider, stunt plane).
		- Have them choose or design their own paper airplane model.
		- Cut the paper to the desired size and shape for their chosen airplane design.
		- Use markers or colored pencils to decorate the paper.
		- Fold the paper to create the chosen airplane model, securing folds with tape.
		- Attach a plastic drinking straw to the bottom of the airplane as a fuselage or support structure.
		- Test the airplane's flight in an open area.

COMPETITION - “Airplane Design Challenge: Soaring Heights”

- Objective: To test and evaluate the performance of the students' airplane designs based on distance, accuracy, and creativity.

- Competition Format:

	1. Distance Challenge (Flight Distance):
		- Each student or team will take turns launching their airplane designs from a designated starting point.
		- Measure the distance traveled by each airplane from the launch point.
		- The airplane that covers the longest distance wins in this category.
		- Encourage students to make adjustments to their designs and compete in multiple rounds to improve their performance.

	2. Accuracy Challenge (Bullseye Target):
		- Set up a target on the ground, which could be a large circle or a "bullseye" made of colorful chalk or tape.
		- Each student or team will take turns launching their airplanes, aiming to land as close to the center of the target as possible.
		- Measure the distance between the center of the target and where each airplane lands.
		- The airplane with the most accurate landing wins in this category.

	3. Creativity Challenge (Design and Presentation):
		- Have a panel of judges (teachers or students) evaluate each airplane's design and presentation.
		- Criteria for evaluation may include creativity, aesthetics, and the uniqueness of design.
		- Students can present their airplanes, explaining their design choices and any improvements made.
		- The airplane with the most creative and well-presented design wins in this category.

	4. Flight Duration Challenge (Hang Time):

		- Each student or team will launch their airplane from a certain height (e.g., a balcony or ladder).
		- Time how long each airplane stays in the air from launch to landing.
		- The airplane with the longest hang time wins in this category.
		- Students can modify their designs to optimize hang time.

	5. Overall Champion:
		- To determine the overall champion, assign points to each category (e.g., 1st place = 5 points, 2nd place = 3 points, 3rd place = 			point).
		- Add up the points from all categories to determine the overall winner.
		- Prizes: You can offer small prizes or certificates to winners in each category and an extra prize for the overall champion.

	6. Rules and Guidelines:

	- Safety First:
		* Emphasize the importance of safety at all times. Students should not aim their airplanes at people, animals, or objects that 				  could be damaged.
	- Ensure that the launch area is clear of obstacles and bystanders.
	Adult supervision is required during launches to prevent accidents.

	- Design Rules:
		* Airplanes must be constructed using the approved materials and within the budget limit (e.g., materials purchased for under $50 			USD).
		* No pre-made, store-bought model airplanes are allowed. The designs must be original or based on common paper airplane designs.
		* Ensure that no sharp or hazardous objects are attached to the airplanes.
	- Fair Play:

		* Students should not tamper with other competitors' airplanes or interfere with their launches.
		* Encourage sportsmanship and respectful behavior among participants.

	- Multiple Rounds:

		* Students can compete in multiple rounds for the Distance and Accuracy Challenges, allowing them to make adjustments and 				improvements 			between rounds.	

	* Specify the number of rounds or attempts allowed for each challenge.
	- Launch Method:

		* Clearly define the launch method for each challenge (e.g., hand launch for distance, throwing from a designated point for 				accuracy, launching from a height for hang time).
		* Ensure that all students have an equal opportunity to launch their airplanes.
	- Design Presentation:

		* In the Creativity Challenge, provide a set time limit for each student or team to present their airplane design to the judges.
		* Encourage students to explain the reasoning behind their design choices and any modifications made to improve performance.
	- Judging Criteria:

		* Clearly outline the judging criteria for each challenge, including specific aspects such as flight distance, accuracy, 				creativity, aesthetics, and hang time.
		* Specify how judges will record and score each aspect.

	- Timekeeping:

		* Appoint timekeepers or use a stopwatch to accurately measure flight duration for the Hang Time Challenge.
		* Ensure that timing is consistent and reliable.

	- Disqualifications:

		* Outline the conditions under which a participant or team may be disqualified from a particular challenge or from the competition 			as a whole. This may include safety violations or cheating.
	- Appeals Process:

		* Establish a clear process for participants to appeal any judgments or disqualifications.
		* Appoint a neutral party to handle appeals and make final decisions.
	- Overall Champion Determination:

		* Clearly explain how the overall champion will be determined, including the method for calculating points across all categories.

	- Prizes and Awards:

		* Specify the prizes or awards that will be given to winners in each category and the overall champion.

	- Post-Competition Discussions:

		* Encourage a post-competition discussion where students can share what they've learned and discuss ways to improve their designs.


Understanding the principles of aerodynamics and the four forces of flight is essential for comprehending how airplanes work. As 			you delve deeper into the world of aviation, you'll discover the fascinating science and engineering behind flight.


* Research and choose one famous airplane in history (e.g., the Wright Brothers' Flyer, the Boeing 747, or the Space Shuttle) and create a 		  short presentation or poster highlighting its significance and key features.

* Write a brief paragraph on why you find airplanes and flight interesting.

I just completed a project for Data Visualisation Portfolio Project. Any feedback is appreciated.

Here’s my project for analysing data of Movies and TV Shows from IMDb.


Have them on github then share the link.