alextheanalyst/portfolioprojects

AlexTheAnalyst

Located here is all documents related to my YouTube channel (AlexTheAnalyst).

All documents are free to download and use as your own.

portfolioprojects's Issues

Tableau final project dataset not available

The dataset required for Tableau final project is not available in the repository. The current dataset mismatches with the dataset used in the tutorial video. Kindly request you to share the dataset used in the YouTube tutorial.

some files don't open

issuing while performing ctc

Error Importing the COVID vaccination table

Hello Alex! Great content on YouTube, Please I am experiencing some issues with importing the table into SQL. I was able to do the covid deaths table, but the covid vaccination table keeps displaying an error message, Kindly find attached a screenshot of the error page. Please how do I rectify this error?

#bug

File not found while downloading the Nashville Housing data

When I click on the download option for the Nashville Housing data, the page buffers for a while and then shows the below error.
https://drive.google.com/file/d/1KvuNOq-lOhx1QiTzajLN6isZjJdPcDKz/view?usp=sharing . So Alex can you please re upload the file or tell us any walkaround for this problem. For now what I've done is, downloaded a similar dataset from Kaggle, let us know what should we do.

Thank you,
Subhankar Sahoo

Global Numbers Error

Recieve This error when putting in the query below: "Msg 245, Level 16, State 1, Line 63
Conversion failed when converting the nvarchar value 'z' to data type int."

Select SUM(new_cases) as total_cases, SUM(cast(new_deaths as int)) as total_deaths, SUM(cast(new_deaths as int))/SUM(New_Cases)*100 as DeathPercentage
From [Portfolio Project]..CovidDeaths
--Where location like '%states%'
where continent is not null
--Group By date
order by 1,2

Conversion failed when converting the nvarchar value '2859.0' to data type int.

Hey, Alex.
I would appreciate it if you could help me, I can't figure out how to fix this error:
Conversion failed when converting the nvarchar value '2859.0' to data type int.

thank you

Select dea.continent, dea.location,
dea.date, dea.population, vac.new_vaccinations
, SUM(CONVERT(int,vac.new_vaccinations)) OVER (Partition by dea.Location Order by dea.location, dea.Date)
as RollingPeopleVaccinated
From Protfolioproject..coviddeaths dea
Join Protfolioproject..covidvaccination vac
On dea.location = vac.location
and dea.date = vac.date
where dea.continent is not null
order by 2,3

Couldn't find API spreadsheet for Cryptal Currency Scraper Project and one video is missing.

Hi Alex,
Thank you so much for your tutorial. But I didn't find the API spreadsheet for Cryptal Currency Scraper Project. Moreover, this project's first part video(between 61 and 62) is missing. Please kindly fix these two issues. Thank you.

Best regards,
Aaron

Covid analysis creating table issue as final output generation issue

Hi at 1:09:14, when creating a table, I have an issue
---- Temp Table

--Drop Table if exists #PercentPopulationVaccinated
--create table #PercentPopulationVaccinated
--(
--continent nvarchar(255),
--location nvarchar(255),
--date datetime,
--population numeric,
--new_vaccinations numeric,
--RollingPeopleVaccinated numeric,
--)

--insert into #PercentPopulationVaccinated
--select dea.continent, dea.location, dea.date datetime, dea.population, vac.new_vaccinations, sum(cast(vac.new_vaccinations as int)) over (partition by dea.location order by dea.location, dea.date) as RollingPeopleVaccinated
--from PortfolioProject..covidDeaths dea
--join PortfolioProject..CovidVaccinations vac
--on dea.location = vac.location
--and dea.date = vac.date
--where dea.continent is not null

--select*, (RollingPeopleVaccinated/population)*100
--from #PercentPopulationVaccinated

//////////////////////ERROR//////////
Msg 213, Level 16, State 1, Line 124
Column name or number of supplied values does not match table definition.

Movie Portfolio Project.ipynb

Could you please upload the dataset which you are using for Movie Portfolio Project.ipynb

help

Can you please tell how to push the SQL project codes into our github repository? it will be very much helpful to me, i will be very much thankful to you sir for this generous act.

Nashville Data set is not found

Hi Sir, Since I was unable to find Nashville dataset from your page ,went to Kaggle and downloaded.

But then when I performed the query on 'Populating property address', I can find that there are 13 more NULL values in new column all with same address (as attached in the screenshot below).
Can you please guide me on this..

Amazon Webscraping issue

Hi Alex,
My Name is Praveen Kumar, I was following your data Analyst Boot Camp. I was at closer to complete the course. but i'm at Amazon Webscraping Module I was getting error to get Price from Amazon. Iwas sharing the screen short of this. Even I tried the code you uploaded in github and i'm getting same error .Please Help to resolve

`
from bs4 import BeautifulSoup
import requests
import time
import datetime

import smtplib

URL = 'https://www.amazon.com/Funny-Data-Systems-Business-Analyst/dp/B07FNW9FGJ/ref=sr_1_3?dchild=1&keywords=data%2Banalyst%2Btshirt&qid=1626655184&sr=8-3&customId=B0752XJYNL&th=1'

headers = {"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36", "Accept-Encoding":"gzip, deflate", "Accept":"text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8", "DNT":"1","Connection":"close", "Upgrade-Insecure-Requests":"1"}

page = requests.get(URL, headers=headers)

soup1 = BeautifulSoup(page.content, "html.parser")

soup2 = BeautifulSoup(soup1.prettify(), "html.parser")

title = soup2.find(id='productTitle').get_text()
print(title)
price = soup2.find(id='priceblock_ourprice').get_text()
print(price)

`

Hi Alex, I have this problem in sql did any body have the same problem

Data Cleaning Portfolio Project Queries. NOT AVAILABLE

Hi, Alex, thanks for your videos. Data Cleaning Portfolio Project QuerieS file is not available, could you please help to share this file.

Error when doing Temp table

Hi Alex, I wanted to say thank you first for your amazing YouTube videos and I definitely think you've made great guidance for us on the journey of Data Analysis :) I really appreciate you!

I had this issue when creating the CTE: "Arithmetic overflow error converting expression to data type int"
...So, instead of converting the sum of vac.new_vaccinations to INT, I converted to BIGINT instead and it worked.

However, I had this issue: "Implicit conversion from data type datetime to numeric is not allowed. Use the CONVERT function to run this query".
OR ERROR "Arithmetic overflow error converting expression to data type int" (when I don't convert it to bigint like above).

Would you please show me how I can figure this out?
Thank you so much Alex :)

Getting Every Value in total_deaths column as NULL.

Hi, I was doing the Covid Data Exploration Project and for the second query I wrote this sql

-- Analyzing the likelihood of death if contracting Covid-19 in a specific country
Select Location,date,total_cases,total_deaths,
CONVERT(DECIMAL(18, 2), (CONVERT(DECIMAL(18, 2), total_deaths) / CONVERT(DECIMAL(18, 2), total_cases)))*100
as DeathPercentage
From Covid_Data_Exploration_Project..CovidDeaths
order by 1,2;

After executing the query I am getting everything in the total_deaths column and DeathPercentage column as NULL.

Can someone help?

Dataset

Im trying to download the covid data set but i cant seem to get it...its a different one on the website