Located here is all documents related to my YouTube channel (AlexTheAnalyst).
All documents are free to download and use as your own.
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.
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?
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
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
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
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
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.
Could you please upload the dataset which you are using for Movie Portfolio Project.ipynb
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.
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..
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
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, thanks for your videos. Data Cleaning Portfolio Project QuerieS file is not available, could you please help to share this file.
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 :)
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?
Im trying to download the covid data set but i cant seem to get it...its a different one on the website
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.