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 🙏🙏🙏🙏
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❣
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
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;
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
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
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
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;
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
@@RiyaRajjjj 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
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
@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.
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.
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!
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
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.
Im trying to learn Data Analytics and i can say i started at right place. Thanks
You can do it!
Please do powerbi project on election dashboard also
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
🙏🙏🙏🙏
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...
Thanks for this sql project it really helped me a lot im understanding the concepts properly
Glad it helped!
Hi, fixed. great video. Honestly your tutorials are the best
Thank you #Datatutorials...
🙏🏻🙏🏻
You are the best brother❤
Hi Swapnjeet, I hope you have plans to create Maven Challenge dashboards and share them with us here on UA-cam.
Hello, Thanks for this
Thank you !
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
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 you sirr
if statewise data sheet not importing check row 49 of the sheet trailing candidate
Thank you bro 👍
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
Hi bro, Data in the statewise_results file is inaccurate. Check State column
Error occurrd while fecting the individual column in tables shows the unknown filed list
Please gove the answer
SIR ONE SQL PROJECT ON ZOMATO DATA PLZZZZZ
There are too many available already on UA-cam, so I did not make one.
can anyone tell while importing constituency wise details tables why its importing only 512 rows out of 8902 rows
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
If we import Data instead of Import flat file so it will showing showing some error
Is this happenn in your case also ?
only partial data can be imported ?
can't upload the state-DETAIL FILE
Sir please suggest any project ideas for SQL
Sure will make a video
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
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.
just one question can we creata a power bi dashboard for this project , is it possible..?
Yes you can create
Your election csv files are not available at the provided link
It is working
State wise results me state column me state name galat de rakhe hain
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
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;
how and where to get dataset sir?
Row number 49 and 218
where is data link
Check description of video please
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
@@RiyaRajjjj 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
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
Any working data analyst here?
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
But sir it is becoming very tough to get a data analytics job
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.
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
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.
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
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
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
Sabme Himachal pradesh hai
hii I am not able to import in mysql workbench there is error utf-8,can anyone suggest solution