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❣
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;
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
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
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)
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
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
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
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.
@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.
![Stromae, Pomme - “Ma Meilleure Ennemie” (from Arcane Season 2) [Official Visualizer]](http://i.ytimg.com/vi/1F3OGIFnW1k/mqdefault.jpg)
![Twenty One Pilots - “The Line” (from Arcane Season 2) [Official Music Video]](http://i.ytimg.com/vi/E2Rj2gQAyPA/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.
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
🙏🙏🙏🙏
Im trying to learn Data Analytics and i can say i started at right place. Thanks
You can do it!
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...
🙏🏻🙏🏻
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...
You are the best brother❤
Hi Swapnjeet, I hope you have plans to create Maven Challenge dashboards and share them with us here on RUclips.
Thank you !
Hello, Thanks for this
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;
if statewise data sheet not importing check row 49 of the sheet trailing candidate
Thank you bro 👍
Hi, can you please share the PPT you are showing in the video?
thanks you sirr
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
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
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
Error occurrd while fecting the individual column in tables shows the unknown filed list
Please gove the answer
Sir please suggest any project ideas for SQL
Sure will make a video
Hi bro, Data in the statewise_results file is inaccurate. Check State column
SIR ONE SQL PROJECT ON ZOMATO DATA PLZZZZZ
There are too many available already on RUclips, so I did not make one.
If we import Data instead of Import flat file so it will showing showing some error
Is this happenn in your case also ?
can anyone tell while importing constituency wise details tables why its importing only 512 rows out of 8902 rows
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
only partial data can be imported ?
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.
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
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)
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;
But sir it is becoming very tough to get a data analytics job
just one question can we creata a power bi dashboard for this project , is it possible..?
Yes you can create
Any working data analyst here?
State wise results me state column me state name galat de rakhe hain
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
Not able to import statewise_results.csv file in mysql. Please help!
@@chiamakaegbulefu6797 If you find any soluntion, then please reply!
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
Your election csv files are not available at the provided link
It is working
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
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
how and where to get dataset sir?
Row number 49 and 218
Statewise_results csv file is full of discrepancies. Check the state column of that csv file
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.
where is data link
Check description of video please
can't upload the state-DETAIL FILE
Same here!
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
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
I think data is incorrect I see indore constituency and state Himachal pradesh
Please correct the data
Sabme Himachal pradesh hai
hii I am not able to import in mysql workbench there is error utf-8,can anyone suggest solution