i am learinng DA skills, and this elections project is one i had in my mind that after learning all necessary skills, i will make a project on elections result but i didn't get data on govt_data portal and on kaggle as well or maybe i am too noob to find it. But now seeing this project its like dream come true. I honestly thank and with whole heart appriciate you who are giving the weak people a chance to learn these skills and earn bread. I really appricate your effort and hardwork. I am finding difficulty in cleaning the data.
Absolutely Loved it Sir, now my confidence is at the peak to gear up for any SQL interviews. kindly replicate the same and showcase your charisma of analysis via power bi 🙏🙏🙏🙏
51:40 Instead of SELECT DISTINCT (COUNT ..., SELECT COUNT(DISTINCT ... should be used. Since COUNT() returns a single integer, the DISTINCT clause has no practical effect This statement first counts the occurrences of a specified column and then returns distinct counts of those results. However, it is important to note that this usage is not common and can lead to confusion. The DISTINCT keyword here applies to the result of the COUNT() function, which typically returns a single value (the total count). Thus, the DISTINCT keyword effectively does not change the output because the count itself will only yield one row
I saw whole video its just awesome!! You are doing great! Just 1 request from me can you create a dashboard on this project using power bi/tableau it will help me to get understand more better Happy to say I am your new subscriber!😊
This type of video is what we exactly need. Please keep making such videos. Thank you! --What is the total number of Seats available for elections in each state? select s.state, COUNT(sw.constituency) as total_seat from states s inner join statewise_results sw on s.State_ID = sw.State_ID group by s.State order by COUNT(sw.constituency) desc;
@1:56:30 can we do this same query without using that where clause im getting same results SELECT TOP 10 s.candidate, s.party, s.evm_votes, t.constituency_name FROM constituencywise_details s INNER JOIN constituencywise_results t ON s.Constituency_ID =t.Constituency_ID ORDER BY s.EVM_Votes DESC;
At 1:57:00 dont understand why we need to use the nested query here this gives same results SELECT top 10 -- s.state, cr.Constituency_Name, cd.Constituency_ID, cd.Candidate, cd.EVM_Votes FROM constituencywise_details cd INNER JOIN constituencywise_results cr ON cd.Constituency_ID = cr.Constituency_ID INNER JOIN statewise_results sr ON cr.Parliament_Constituency = sr.Parliament_Constituency INNER JOIN states s ON s.State_ID = sr.State_ID ORDER BY cd.EVM_Votes DESC;
yes bro same doubt here even i done it simple like this SELECT cr.`Constituency Name`, cd.Candidate, cd.`EVM Votes` FROM constituencywise_details cd JOIN constituencywise_results cr ON cd.`Constituency ID` = cr.`Constituency ID` ORDER BY cd.`EVM Votes` DESC LIMIT 10;
@datatutorials for the second question I have connected the constituency results with state results as it also have state name. I have joined using parliament constituency column and grouped by state mentioning that column but my answer are different it's only showing 11 states? Can you explain the reason behind it SELECT COUNT(CR.Parliament_Constituency) AS [Total Seats], SR.State FROM constituencywise_results AS CR JOIN statewise_results AS SR ON CR.Parliament_Constituency = SR.Parliament_Constituency GROUP BY SR.State; this is my code. I think both your code and my code are logically crt but why the answers differ?
for this question why to use nested query and all u can get It easily right in this way #13 which candidate recieved the highest evm votes in each constituency top 10 SELECT cr.`Constituency Name`, cd.Candidate, cd.`EVM Votes` FROM constituencywise_details cd JOIN constituencywise_results cr ON cd.`Constituency ID` = cr.`Constituency ID` ORDER BY cd.`EVM Votes` DESC LIMIT 10;
Im facing issue to uploading file "Statewise_result.csv"in MySQL. kindly help me. its showing UTF-8 issue . i did tried to resave the file in normal Comma Seperated but its not working ...
i am also facing the same issue while import the state_wise_result and have also set another name save as utf-8 delimated still error shows ..... i have also one more issue while importing the constituency_wise_details csv in mysql workbench the data not entriely return in my sql workbench its returns only 512 rows.. please resolve this or give it a solution Sir ??
@sanketsorte Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
in my sql workbench i am not unable to upload the statewise result tableit show me "Unhandled exception: 'charmap' code can't decode byte 0x9d in position 5346; error
Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
@@SURAJKUMAR-dx1uz Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try. Save with utf 8 and try giving different name
select distinct state, count(parliament_constituency) as[state wise parliament seats] from statewise_results group by State why im getting wrong ans i mean though im getting 543 seats but im not getting all states please help for second question
can anyone help me to know why I'm not able to upload the tables in pgadmin4 ,i have downloaded all the 4 csv files and stored them in local folder but after creating database not bale to upload them.
Close the excel tab which you have already opened to save the file then import the file in SQL , you cannot import data in SQL which is already opened in another tab. Hope your problem solved😊
Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
I am not able to import the statewise_results table in MySQL. It is showing error "UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 5347: character maps to ". Please tell me how to resolve this
Unhandled exception: 'charmap' codec can't decode byte 0x9d in position 5347 : character maps to Check the log for more detail. im getting this error while uploading statewise_result csv file in mysql all other are uploaded successfully.Please help
while i was trying to import "statewise_results" in MYSQL Workbench i was receiving error such as "unhandled exception: 'charmap' codec can't decode byte 0x81" how to solve this sir?
While importing state wise_result.. in MySQL workbench..it shows an error....unhandled exception..pls sir make video or reply that how to fix this error so we can work further in the project
Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try. Save with utf 8 and try giving different name
error code table india_election_result24.state does not exit . trying to solve total number of seats state wise. still coming up this table does not exit. any solution pls
hey try converting the csv file to json file and there itself change the name of the header (for ex. from % of voted to of_votes) and then import the data. Hoping this helps.
SELECT cd.EVM_Votes, cd.Postal_Votes, cd.Total_Votes, cd.Candidate, cr.Constituency_Name FROM constituencywise_results cr JOIN constituencywise_details cd ON cr. constituency_ID = cd. constituency_ID WHERE cr.Constituency_Name = 'BEED' While executing the command I am only getting the column name and the not full list of table. Can you please help fixing this
In MySql server I am trying to import 1st CSV file which has 8902 rows, using Table Data Import Wizard. After importing it is showing only 512 rows. I didn't get any error. Please help me to fix this. Also, unable to import Statewise_results as it is showing below error "Unhandled exception: 'charmap' codec can't decode byte 0x9d in position 5347: character maps to Check the log for more details" Please assist. Thank you!
@Lifemotivation.l Please check csv file at row num 49 there is some corrupt data "“BHAYAâ€" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
sir,please also tell us how to upload in github, it make more use full for us... , do it for 1 sql project, 1 power BI project, that's enough....., and this is my comment on youtube,because i have never ever seen the teacher like you.....with hope❣
Pls do this one sir it Will help us lot really your teaching skill is awesome if a guy knows only basic SQL if he sees your video definitely he will get an idea from my bottom of my heart thank you so much sir 😊😊
NOT ABLE TO IMPORT THE DATA Microsoft SQL Server Management Studio Power BI SQL Pro Error inserting data into table. (Microsoft.SqlServer.Import.Wizard) Additional information: Error inserting data into table. (Microsoft.SqlServer.Prose.Import) The given value 'Veerath Thiyagi Viswanathadoss Thozhilalarkal Katchi of type String from the data source cannot be converted to type nvarchar for Column 2 [Party]. (Microsoft.Data.SqlClient) →String or binary data would be truncated in table [dbo].[constituencywise_details ]', column 'Party'. Truncated value: 'Veerath Thiyagi Viswanathadoss Thozhilalarkal Katc'. (Microsoft.Data.SqlClient)
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
This type of video is what we exactly need.
Please keep making such videos. Thank you!
Thank you, I will
i am learinng DA skills, and this elections project is one i had in my mind that after learning all necessary skills, i will make a project on elections result but i didn't get data on govt_data portal and on kaggle as well or maybe i am too noob to find it. But now seeing this project its like dream come true. I honestly thank and with whole heart appriciate you who are giving the weak people a chance to learn these skills and earn bread. I really appricate your effort and hardwork. I am finding difficulty in cleaning the data.
The Project is very Awesome and its my first my SQL Project
Thanks for this sql project it really helped me a lot im understanding the concepts properly
Glad it helped!
Absolutely Loved it Sir, now my confidence is at the peak to gear up for any SQL interviews.
kindly replicate the same and showcase your charisma of analysis via power bi
🙏🙏🙏🙏
Please do powerbi project on election dashboard also
Hi, fixed. great video. Honestly your tutorials are the best
Im trying to learn Data Analytics and i can say i started at right place. Thanks
You can do it!
I really appreciate your efforts 🙏🏻 Thank you sir
51:40
Instead of SELECT DISTINCT (COUNT ..., SELECT COUNT(DISTINCT ... should be used. Since COUNT() returns a single integer, the DISTINCT clause has no practical effect
This statement first counts the occurrences of a specified column and then returns distinct counts of those results. However, it is important to note that this usage is not common and can lead to confusion. The DISTINCT keyword here applies to the result of the COUNT() function, which typically returns a single value (the total count). Thus, the DISTINCT keyword effectively does not change the output because the count itself will only yield one row
I saw whole video its just awesome!! You are doing great!
Just 1 request from me can you create a dashboard on this project using power bi/tableau it will help me to get understand more better
Happy to say I am your new subscriber!😊
Thank you #Datatutorials...
🙏🏻🙏🏻
You are the best brother❤
Thank you !
Hello, Thanks for this
if statewise data sheet not importing check row 49 of the sheet trailing candidate
Thank you bro 👍
thank you so much
you are a savior, been struggling the whole day. thank you
thanks you sirr
This type of video is what we exactly need.
Please keep making such videos. Thank you!
--What is the total number of Seats available for elections in each state?
select s.state, COUNT(sw.constituency) as total_seat
from states s
inner join statewise_results sw on
s.State_ID = sw.State_ID
group by s.State
order by COUNT(sw.constituency) desc;
Thanks
State wise results me state column me state name galat de rakhe hain
Hi, can you please share the PPT you are showing in the video?
Hi bro, Data in the statewise_results file is inaccurate. Check State column
Please make power bi project also on this dataset.
Ecommerce/ Retail ka ek project in power bi and excel me upload kardo bhaiya 😊
Brother can you make one power BI project on this topic
In progress, will be uploaded soon
@@datatutorials1 Thanks brother
please do a project on e commerce domain🙏🙏🙏🙏🙏🙏
Sir please make a power bi dashboard for it
@1:56:30 can we do this same query without using that where clause im getting same results
SELECT TOP 10
s.candidate,
s.party,
s.evm_votes,
t.constituency_name
FROM constituencywise_details s
INNER JOIN constituencywise_results t ON s.Constituency_ID =t.Constituency_ID
ORDER BY s.EVM_Votes DESC;
If we import Data instead of Import flat file so it will showing showing some error
Is this happenn in your case also ?
how you calculated total parties for maharastra there are more than 7 parties in maharastra.
Error occurrd while fecting the individual column in tables shows the unknown filed list
Please gove the answer
At 1:57:00
dont understand why we need to use the nested query here
this gives same results
SELECT top 10
-- s.state,
cr.Constituency_Name,
cd.Constituency_ID,
cd.Candidate,
cd.EVM_Votes
FROM
constituencywise_details cd
INNER JOIN
constituencywise_results cr
ON cd.Constituency_ID = cr.Constituency_ID
INNER JOIN
statewise_results sr
ON cr.Parliament_Constituency = sr.Parliament_Constituency
INNER JOIN
states s
ON s.State_ID = sr.State_ID
ORDER BY
cd.EVM_Votes DESC;
yes bro same doubt here even i done it simple like this
SELECT
cr.`Constituency Name`, cd.Candidate, cd.`EVM Votes`
FROM
constituencywise_details cd
JOIN
constituencywise_results cr ON cd.`Constituency ID` = cr.`Constituency ID`
ORDER BY cd.`EVM Votes` DESC
LIMIT 10;
only partial data can be imported ?
SIR ONE SQL PROJECT ON ZOMATO DATA PLZZZZZ
There are too many available already on RUclips, so I did not make one.
@datatutorials for the second question I have connected the constituency results with state results as it also have state name. I have joined using parliament constituency column and grouped by state mentioning that column but my answer are different it's only showing 11 states? Can you explain the reason behind it
SELECT
COUNT(CR.Parliament_Constituency) AS [Total Seats],
SR.State
FROM
constituencywise_results AS CR
JOIN statewise_results AS SR
ON CR.Parliament_Constituency = SR.Parliament_Constituency
GROUP BY SR.State; this is my code. I think both your code and my code are logically crt but why the answers differ?
for this question why to use nested query and all u can get It easily right in this way
#13 which candidate recieved the highest evm votes in each constituency top 10
SELECT
cr.`Constituency Name`, cd.Candidate, cd.`EVM Votes`
FROM
constituencywise_details cd
JOIN
constituencywise_results cr ON cd.`Constituency ID` = cr.`Constituency ID`
ORDER BY cd.`EVM Votes` DESC
LIMIT 10;
Im facing issue to uploading file "Statewise_result.csv"in MySQL. kindly help me. its showing UTF-8 issue . i did tried to resave the file in normal Comma Seperated but its not working ...
Save with utf 8 and try giving different name
@@datatutorials1 i did but not working
i am also facing the same issue while import the state_wise_result and have also set another name save as utf-8 delimated still error shows .....
i have also one more issue while importing the constituency_wise_details csv in mysql workbench the data not entriely return in my sql workbench its returns only 512 rows.. please resolve this or give it a solution Sir ??
Import it through command prompt
@sanketsorte Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
Could u send the data that used?
Hi bro
where did you download the dataset from
Kaggle
in my sql workbench i am not unable to upload the statewise result tableit show me "Unhandled exception: 'charmap' code can't decode byte 0x9d in position 5346; error
bro did you found the solution for this problem ?
@Peaceselam145 In statewise_results table check column "Trailing Candidate" at line no 49 just remove "“BHAYAâ€" after URMILA JAIN. it will work.
Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
@@SURAJKUMAR-dx1uz remove that "BHAYA" in row 49 where URMILA JAIN "BHAYA" (trailing column) and just keep URMILA JAIN and it works fine
@@SURAJKUMAR-dx1uz Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try. Save with utf 8 and try giving different name
DOES IT CONTAIN PYTHON/JAVA?
select distinct state, count(parliament_constituency) as[state wise parliament seats]
from statewise_results
group by State
why im getting wrong ans i mean though im getting 543 seats but im not getting all states
please help for second question
just one question can we creata a power bi dashboard for this project , is it possible..?
Yes you can create
I am unable to import statewise result file in sql. can anyone help me with this?
remove "BHAYA"(it has some charmap issue) in row 49 where URMILA JAIN "BHAYA" (trailing candidate column) and just keep URMILA JAIN and it works fine
@@siddharthballure thank for your reply. it helped me
@@akshatarangari6796 Great work bro thank you
can anyone help me to know why I'm not able to upload the tables in pgadmin4 ,i have downloaded all the 4 csv files and stored them in local folder but after creating database not bale to upload them.
even i'm facing error while uploading csv files
Your election csv files are not available at the provided link
It is working
in my sql workbench i am not able to upload the statewise result table it throws an error
what to do
me too facing the same error. couldn't identify the problem.
Close the excel tab which you have already opened to save the file then import the file in SQL , you cannot import data in SQL which is already opened in another tab.
Hope your problem solved😊
Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
I am not able to import the statewise_results table in MySQL. It is showing error "UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 5347: character maps to ".
Please tell me how to resolve this
Check 49 remove unwanted characters from the column of trailing candidates and insert again
@@aathiram717 Thanks a ton brother, it worked!! I was also facing the same issue and tried everything but nothing worked.
how and where to get dataset sir?
Row number 49 and 218
where is data link
Check description of video please
Unhandled exception: 'charmap' codec can't decode byte 0x9d in position 5347 : character maps to
Check the log for more detail. im getting this error while uploading statewise_result csv file in mysql all other are uploaded successfully.Please help
while i was trying to import "statewise_results" in MYSQL Workbench i was receiving error such as
"unhandled exception: 'charmap' codec can't decode byte 0x81"
how to solve this sir?
Check for some error in cell data
how to check those errors
While importing state wise_result.. in MySQL workbench..it shows an error....unhandled exception..pls sir make video or reply that how to fix this error so we can work further in the project
Please check csv file at row num 49 there is some corrupt data "“BHAYA†" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try. Save with utf 8 and try giving different name
error code table india_election_result24.state does not exit . trying to solve total number of seats state wise. still coming up this table does not exit. any solution pls
Database you are using??
@@datatutorials1 yes
How it's possible two primary keys in the same table ?
Ideally it should be one, the data isn’t structured and in format we need. We have this just for understanding
@@datatutorials1 thank you, I get it
Not able to import statewise_results.csv file in mysql. Please help!
@@chiamakaegbulefu6797 If you find any soluntion, then please reply!
bro did the problem got resolved
can anyone tell while importing constituency wise details tables why its importing only 512 rows out of 8902 rows
HI... I am also stuck with the same problem... did u find the solution?
Hey did u find the solution i stuck with this problem
its been 4 days and cannot import the two file in mysql workbench please help?
bro convert csv file to sql file from chrome then upload the data
hey try converting the csv file to json file and there itself change the name of the header (for ex. from % of voted to of_votes) and then import the data. Hoping this helps.
SELECT
cd.EVM_Votes,
cd.Postal_Votes,
cd.Total_Votes,
cd.Candidate,
cr.Constituency_Name
FROM
constituencywise_results cr JOIN constituencywise_details cd ON cr. constituency_ID = cd. constituency_ID
WHERE cr.Constituency_Name = 'BEED'
While executing the command I am only getting the column name and the not full list of table. Can you please help fixing this
In MySql server I am trying to import 1st CSV file which has 8902 rows, using Table Data Import Wizard. After importing it is showing only 512 rows. I didn't get any error. Please help me to fix this.
Also, unable to import Statewise_results as it is showing below error "Unhandled exception: 'charmap' codec can't decode byte 0x9d in position 5347: character maps to Check the log for more details"
Please assist. Thank you!
ya same problem i am also encountering did you found the solution for the problem?
@@SURAJKUMAR-dx1uz same problem for me as well. please update if u find the solution
@@SURAJKUMAR-dx1uz Not yet
I am also facing the very same issue.
same im also facing the same issue
Utf 8 showing in state wise data
@Lifemotivation.l Please check csv file at row num 49 there is some corrupt data "“BHAYAâ€" added in "Trailing Candidate" column in cell Urmila Jain.. remove that again try.
@@priyankasurve7311 getting same error
Sir please suggest any project ideas for SQL
Sure will make a video
sir,please also tell us how to upload in github, it make more use full for us... , do it for 1 sql project, 1 power BI project, that's enough....., and this is my comment on youtube,because i have never ever seen the teacher like you.....with hope❣
Will upload soon
@@datatutorials1 thank you sir...
Pls do this one sir it Will help us lot really your teaching skill is awesome if a guy knows only basic SQL if he sees your video definitely he will get an idea from my bottom of my heart thank you so much sir 😊😊
can't upload the state-DETAIL FILE
Same here!
But sir it is becoming very tough to get a data analytics job
Any working data analyst here?
NOT ABLE TO IMPORT THE DATA
Microsoft SQL Server Management Studio
Power BI SQL Pro
Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)
Additional information:
Error inserting data into table. (Microsoft.SqlServer.Prose.Import)
The given value 'Veerath Thiyagi Viswanathadoss Thozhilalarkal Katchi of type String from the data source cannot be converted to type nvarchar for Column 2 [Party]. (Microsoft.Data.SqlClient)
→String or binary data would be truncated in table [dbo].[constituencywise_details ]', column 'Party'. Truncated value: 'Veerath Thiyagi Viswanathadoss Thozhilalarkal Katc'. (Microsoft.Data.SqlClient)
BRO you have select task then import flat file not import.
Sabme Himachal pradesh hai
I think data is incorrect I see indore constituency and state Himachal pradesh
Please correct the data
@@datatutorials1 its full of errors
Statewise_results csv file is full of discrepancies. Check the state column of that csv file
hii I am not able to import in mysql workbench there is error utf-8,can anyone suggest solution