I have already learned Python, SQL, Power BI, Tableau, Excel. I have done many projects as well as uploaded on GitHub and LinkedIn but still I am not getting any job due to lack of real-life experience though I have done few internships and Accenture and quantium job simulations also. Will you guide me how can I get job if I talk to you? Will I get recommendation?
Mam This project help me a lot🤗🤗 if you have time so kindly create a complete end to end portfolio project for data analyst and data scientist if you read this message hit like on this comment😊😊😊
this is coming at the right for me. thank you so much for dedicating your time to provide this. It's an inspiration to me as a data science student. thank you.
@@techclasses0810 one thing i would like to add is you havent used time series & forecasting analysis properly u can google more on this ARIMA models are very much helpful.
Good job Ayushi! You have touched almost every important point in this video. Freshers and even some experienced people can learn a lot from this video because this is how things are done in real life when you work in a team along with data scientists.
ohh wow you are awesome in explaining things so easily. i found this video very useful and helpful to understand data Analytics using SQL and Python in such a short time. Cheers to you :) I loved it. keep up the good posts and grow.
Unfortunately, copy-paste content providers always have more followers than those with superior knowledge. On that note, you deserve greater attention as you've inspired many people, particularly those genuinely interested in technology. Out of curiosity 🤔, do you provide any guidance to experienced professionals who are already in the Data domain??
In companies, you will not be asked to do so if you have to create a complete analysis task. Just writing queries and fetching data is not what you will do in company, any database manager can do this
You can ask me on my mail id or insta. I will help you in that. Also, the code is already taught in the lectures, and the code is working perfectly fine. thousands of students are using it and they have not faced any kind of issues.
getting this error --------------------------------------------------------------------------- MemoryError Traceback (most recent call last) Cell In[2], line 18 15 tip_df = pd.DataFrame(tip_data) 17 with open('yelp_academic_dataset_user.json', 'r',encoding='utf-8') as f: ---> 18 user_data = [json.loads(line) for line in f] 19 user_df = pd.DataFrame(user_data) Cell In[2], line 18, in (.0) 15 tip_df = pd.DataFrame(tip_data) 17 with open('yelp_academic_dataset_user.json', 'r',encoding='utf-8') as f: ---> 18 user_data = [json.loads(line) for line in f] 19 user_df = pd.DataFrame(user_data) File :322, in decode(self, input, final) MemoryError:
@@techclasses0810 I'm not getting any error just table is not coming. I tried with other db file in MySQL same no table is there.though I have table in database file
🔥 Book 1:1 call with me (Career Guidance, Resume Review, LinkedIn Profile Review) : topmate.io/ayushi_mishra/133733
I have already learned Python, SQL, Power BI, Tableau, Excel. I have done many projects as well as uploaded on GitHub and LinkedIn but still I am not getting any job due to lack of real-life experience though I have done few internships and Accenture and quantium job simulations also. Will you guide me how can I get job if I talk to you? Will I get recommendation?
@@AnalystWallah sure, we can discuss what’s going wrong with your application
Where's the code git file?
Please help.
Please prepare one project for me .I can pay you.
Mam showing unicodedecode error
this is a masterpiece. how I wish you did it in English but since we understand we can still follow. thanks, from Nairobi, Kenya.
Mam This project help me a lot🤗🤗 if you have time so kindly create a complete end to end portfolio project for data analyst and data scientist if you read this message hit like on this comment😊😊😊
Great Overall end to end explanation was too good, I want to learn SQL & Python...
Truly valuable content and most honest data analyst coach on youtube . better than a lot of top channels who make videos on data analysis.
great over all.... I am interest learn SQL& Python
this is coming at the right for me. thank you so much for dedicating your time to provide this. It's an inspiration to me as a data science student. thank you.
Great Analysis project. Thanks for sharing. Keep up the good work
Excellent video till date i have ever seen on data analytics.
Glad it was helpful! Thank you
@@techclasses0810 one thing i would like to add is you havent used time series & forecasting analysis properly u can google more on this
ARIMA models are very much helpful.
For the research question I used, forecasting is not necessary that's why I have not used ARIMA, SARIMA.
Good job Ayushi!
You have touched almost every important point in this video.
Freshers and even some experienced people can learn a lot from this video because this is how things are done in real life when you work in a team along with data scientists.
This is truly one of best tutorial
😍🤩
Make end to end power BI project which include data modelling and Dax as well to showcase those in resume
+1
Hello mam you are doing a great job
Thanks a lot, just trying to use my knowledge and experience to help data analyst aspirants.
ohh wow you are awesome in explaining things so easily. i found this video very useful and helpful to understand data Analytics using SQL and Python in such a short time. Cheers to you :) I loved it. keep up the good posts and grow.
Thank you so much
Can you add English subtitles
An English version, PLEASE... THANK YOU
In resume, What should I write for this project can you please explain in bullet points
This is a combination of both python and sql
you should make a video on uploading the dataset and the initial steps..i m facing problem to load these review and user data.each dataset is 4-3 gb
I have already shown from where to download and what code will be used to upload the json files in database
Bro, can you help me if you are able to do the project
Problem statement client ke dwara di jati hogi ?
Mam dealing with error as the data size is huge unable to loading
Thank you Didi.
Glad it is helpful…😇
Great Overall end to end explanation was too good❤.
Thank you 🙌
Wonderful mam
Thank you
Unfortunately, copy-paste content providers always have more followers than those with superior knowledge.
On that note, you deserve greater attention as you've inspired many people, particularly those genuinely interested in technology.
Out of curiosity 🤔, do you provide any guidance to experienced professionals who are already in the Data domain??
Thank you so much for your kind words. And i provide guidance but only to those who are looking get job in data field
I get stuck in loading datasets like how to read JSON files as tables using SQL query, even if I followed the same 😢😢😢
please upload the 2nd part of camp web application
I'm trying to connect database but table is not coming though table is in database.
mam do i need to download files because they are very large and then perform the queries in jupyter notebook??
You need to download files then upload in database and perform queries
@@techclasses0810 Thanks mam
It's telling no module named folium
How to make yelp.db where is the database. I have downloaded five json files
In the video i have shown the code for creating database
It worked but finally I got MemoryError mam while open syntax of 5 json files ,how to solve that is there any way😢
madam aise aur project bhi banaiye......
Mam, can you explain in English so that everyone can understand
Getting MemoryError
Can you explain in English so that everyone can understand
why are you writing sql query on notebook? you can easily write the queries on sql server or any other platform?
In companies, you will not be asked to do so if you have to create a complete analysis task. Just writing queries and fetching data is not what you will do in company, any database manager can do this
hello please help me to know about sql please
Please make a video of dashboard with this project .
Yes please
Ayushi is there any other option to load review.json file as its take too much time in loading ?
You can try other sql methods, like mysql etc
Iam getting AttributeError: 'str' object has no attribute 'read' this error while loading json file can you help me to solve the issue.
Kindly share a screenshot of the error on my insta, will help.
maam in starting apne files open karne k liye sabhi me 'as f' kyu liya hai?
it is used for string formatting
apne kaha se shika hai maam ..
I am getting empty putput after running display command. Can you tell me how to enter data into yelp db.
The database connection notebook I have shown in the video, you can follow the same to insert tables
mam, can you make project that belong to finance side
Sure.
hello maam can i use my approach for solving this project and post it on linkedin?
Yes sure
is there someone else who faced synatx error in these codes?
Yes bro me too
Please reply and help me if you know how to do it
Please Can someone review the package she's providing in 599+ (4 Projects)is it worth buying?
Ma’am I want to buy that package but what if I face errors or issue while creating a project?
You can ask me on my mail id or insta. I will help you in that. Also, the code is already taught in the lectures, and the code is working perfectly fine. thousands of students are using it and they have not faced any kind of issues.
@@techclasses0810 Okayy Thanksss
how much will it take to load a file in a jupyter notebook??
Depends on the data size you are fetching. Large data size will take longer to load.
English?? Please
while creating a database the system is not responding the * is still their , how to resolve this
getting this error
---------------------------------------------------------------------------
MemoryError Traceback (most recent call last)
Cell In[2], line 18
15 tip_df = pd.DataFrame(tip_data)
17 with open('yelp_academic_dataset_user.json', 'r',encoding='utf-8') as f:
---> 18 user_data = [json.loads(line) for line in f]
19 user_df = pd.DataFrame(user_data)
Cell In[2], line 18, in (.0)
15 tip_df = pd.DataFrame(tip_data)
17 with open('yelp_academic_dataset_user.json', 'r',encoding='utf-8') as f:
---> 18 user_data = [json.loads(line) for line in f]
19 user_df = pd.DataFrame(user_data)
File :322, in decode(self, input, final)
MemoryError:
Its a memory error, you can try using mysql and insert data in the database
@@techclasses0810 okay ma'am.
How to use mysql when getting memory error?
Uff ye tumbnails kitne cute h.....
tables daal ke run karne par output empty aa raha hai
Do you have your database file in your folder where your code is?
@@techclasses0810 haa but ek folder me nhi aa raha ...yelp.db naam ka folder automatic create ho gya lekin empty hai wo
@@rohangupta5157 after database creation you need to insert the table as well
Data analyst ki job mai English nahi aati to kuch nahi ho saktaa
Right..
abhi job milegi kya analytics me ???
Job is there but companies are only looking for a skilled freshers
You took a very huge dataset It is not possible to load a 4 gb file in your local system and then make a project
That is why I used SQL to load only that data required for analysis, just like we do in real time.
I'm trying to connect database but table is not coming though table is in database.
What error you are facing?
@@techclasses0810 I'm not getting any error just table is not coming.
I tried with other db file in MySQL same no table is there.though I have table in database file