![DScience Concept](/img/default-banner.jpg)
- 61
- 63 303
DScience Concept
India
Приєднався 2 жов 2020
DScience Concept shares industry experience to aspiring and novice data scientists free of cost. As a machine learning trainer and full time working professional I understand the conceptual gap between academy and industry. The aim of this channel is to fill any such gaps. Any industry may demands basic skillset but data science jobs demand little higher. So, let's skillup today for up-skilled tomorrow.
Sales Data Case Study With Pandas | Case Study With Pandas Interview Questions
Detailed Sales Data Case Study With Pandas | Case Study With Pandas Interview Questions
#datascience #data #dataanalytics #machinelearning #datascientist #dataanalysis
00:00 Introduction
00:56 Feature Engineering - Derived Features
01:16 Feature Engineering Challenges
01:59 Feature Engineering Dependancy
03:13 Example 1 - Degree of difficulty - Easy
06:37 Example 2 - Degree of difficulty - Medium
12:13 Example 3 - Degree of difficulty - Hard
#datascience #data #dataanalytics #machinelearning #datascientist #dataanalysis
00:00 Introduction
00:56 Feature Engineering - Derived Features
01:16 Feature Engineering Challenges
01:59 Feature Engineering Dependancy
03:13 Example 1 - Degree of difficulty - Easy
06:37 Example 2 - Degree of difficulty - Medium
12:13 Example 3 - Degree of difficulty - Hard
Переглядів: 77
Відео
BOOK Emergency SLOT In 4 STEPS For USA F1-VISA Interview
Переглядів 4339 місяців тому
BOOK Emergency SLOT In 4 STEPS For USA F1-VISA Interview #f1#f1visa #highereducation #studyabroad #students #f1visainterview #students #studyabroad #studyinusa #f1 #usa #ds160 #f1visainterviewquestions #usavisa Related Videos: 1. Change/update University/DS160/SEVIS after interview booked ua-cam.com/video/EgLYqLBbCDw/v-deo.html 2. Steps to reschedule VISA interview ua-cam.com/video/uTwnrJSOaF4/...
Python Pandas DataFrame | Adding New Column
Переглядів 849 місяців тому
#python #pandas #pandastyle #dataframes #dataframe #dataanalytics #datascience #dataanalytics
Apply complex filter easily using Python Where Method
Переглядів 82Рік тому
Apply complex filter easily using Python Where Method
QUESTION 4 - Pandas Interview Questions | Pandas Interview Questions For Data Science
Переглядів 546Рік тому
QUESTION 4 - Pandas Interview Questions | Pandas Interview Questions For Data Science
QUESTION 3 - Pandas Interview Questions Series | Pandas Interview Questions For Data Science Series
Переглядів 922Рік тому
QUESTION 3 - Pandas Interview Questions Series | Pandas Interview Questions For Data Science Series
Part 1 | Top Pandas Interview Questions And Answers
Переглядів 4 тис.Рік тому
Part 1 | Top Pandas Interview Questions And Answers
Part-B | Top SQL Interview Questions and Answers | SQL Interview Preparation | SQL for Data Science
Переглядів 184Рік тому
Part-B | Top SQL Interview Questions and Answers | SQL Interview Preparation | SQL for Data Science
QUESTION 2 - Pandas Interview Questions Series | Pandas Interview Questions Series For Data Science
Переглядів 1,5 тис.Рік тому
QUESTION 2 - Pandas Interview Questions Series | Pandas Interview Questions Series For Data Science
QUESTION 1 - Pandas Interview Questions Series | Pandas Interview Questions Series For Data Science
Переглядів 4,3 тис.2 роки тому
QUESTION 1 - Pandas Interview Questions Series | Pandas Interview Questions Series For Data Science
Data Science Syllabus Chapter 7 | Data Science Syllabus SQL
Переглядів 1072 роки тому
Data Science Syllabus Chapter 7 | Data Science Syllabus SQL
Data Science Syllabus Chapter 6 | Data Science Syllabus Visualization
Переглядів 1062 роки тому
Data Science Syllabus Chapter 6 | Data Science Syllabus Visualization
Data Science Syllabus Chapter 5 | Data Science Syllabus Deep Learning
Переглядів 1012 роки тому
Data Science Syllabus Chapter 5 | Data Science Syllabus Deep Learning
Data Science Syllabus Chapter 4 | Data Science Syllabus DS/ML Fundamental
Переглядів 1272 роки тому
Data Science Syllabus Chapter 4 | Data Science Syllabus DS/ML Fundamental
Data Science Syllabus Chapter 3 | Data Science Syllabus ML Algorithm
Переглядів 1432 роки тому
Data Science Syllabus Chapter 3 | Data Science Syllabus ML Algorithm
Data Science Syllabus Chapter 2 | Data Science Syllabus Statistics
Переглядів 2292 роки тому
Data Science Syllabus Chapter 2 | Data Science Syllabus Statistics
Introduction To Data Science Syllabus | Data Science Syllabus Chapter 0
Переглядів 3412 роки тому
Introduction To Data Science Syllabus | Data Science Syllabus Chapter 0
PyTorch Quick Tip || Reproducible Results and Deterministic Behavior
Переглядів 1822 роки тому
PyTorch Quick Tip || Reproducible Results and Deterministic Behavior
Change University Before Visa Interview | Change University/DS160 After US Visa Slot Booking
Переглядів 13 тис.2 роки тому
Change University Before Visa Interview | Change University/DS160 After US Visa Slot Booking
Reschedule US Visa Appointment IN 4 STEPS | How to reschedule US Visa Appointment
Переглядів 12 тис.2 роки тому
Reschedule US Visa Appointment IN 4 STEPS | How to reschedule US Visa Appointment
Book Early Visa Appointment Date | Schedule Early Visa Appointment Slot In 4 Steps
Переглядів 4472 роки тому
Book Early Visa Appointment Date | Schedule Early Visa Appointment Slot In 4 Steps
Must-see Tips For Finding The Right University For You | The Best University: Tips And Tricks
Переглядів 1,1 тис.2 роки тому
Must-see Tips For Finding The Right University For You | The Best University: Tips And Tricks
Hi i started my application on spring intake 2023 i have A university then i have booked my visa for dec then due to delay in loan process i haven’t gone to the biometric it got cancelled automatically and i havent payed sevis fee due to loan issue now for fall 24 intake i have the option for reschedule but i have better university B so how can i change my university is it a problem please help should I close and start a new application by paying again?
Hello There, in your case you need to fill a new DS160 form with details of new university. Carry this ds160 form along with old appointment letter. On the biometric day, specify to the officer that you have changed your university after slot appointment booking. This is all you need to do. All the best for your upcoming interviews!!
Hi i started my application on spring intake 2023 i have A university then i have booked my visa for dec then due to delay in loan process i haven’t gone to the biometric it got cancelled automatically and i havent payed sevis fee due to loan issue now for fall 24 intake i have the option for reschedule but i have better university B so how can i change my university is it a problem please help should I close and start a new application by paying again?
Hello Tarun, this is replied on your other comment. Let me know if you have more questions. Good luck with interview!!
Thank you 😅
Which date should we fill up in travel date
Great question soni!! The date need not be the exact one but any date closure to your school start date or orientation date.
What if i don’t have this option in this page??
Can you please be specific about option of interest here?
Genuine suggestion will be respected I am at this moment but I have submitted ds 160 already Can I fill another ds 160 is it good or hamper visa interview??
Hello Sakar, I am sorry but I failed to understand your case. Can you please elaborate?
Hello madam, I am not able to see emergency appointment option. I have only scheduled ones so far ? What Can I do ? is there any valid contact email address to contact and ask such doubts ?
Hello Subashree, sorry for the late reply. I hope you have got an emergency appointment by now. Feel free to share your interview experience if you have already attended one. Thanks.
please share the dataset.
Please Like, Subscribe to support us.
Excellent video, good work.
Appreciated 🙏
'promo sm' 😌
Hi your video helps a lot ! I have created a new DS-160 and got confirmation, now before I head to OFC for biometrics, shall I have to do the SEVIS transfer? Please help
Happy to help! Can you please elaborate your case? I want to be sure of it before recommending anything?
Awesome tutorial. Unique = distinct Value_count= frequency. Value_count = group_by()[].count() How to get in a dataframe aggregation count and sum simultaneously without merging?
Thank you for content quality validation! Very good question. The answer is using agg() method. Agg application can be watched in ua-cam.com/video/DqiY5EmoHvs/v-deo.html.
Hello can I reschedule my appointment to the earlier date from my original date?
Yes. Technically it's possible to reschedule appointment to earlier date from original slot. But, you may not get to see earlier slots often not because it's not supported (as I cleared before) but due to high demand of slots. As every minutes 1000s students seek earlier slot availability, its high chance that you will not see earlier availability. As an alternative solution, you can request for F1 VISA Emergency Appointment. Once EA request approved, you will get earlier slot for guaranteed. Please validate EA request eligibility thoroughly. Best of Luck!
link of the dataset?
Thinks
Hello ma'am I am only able to get ofc date and not able to get date for interview even though I had applied for emergency appointment, what does it mean?
Hello Sujata, it could mean VAC slots are not available now. Whenever, it will avail book it. Keep monitoring for availability. Best of luck!!
@@dsconcept20 thank you for your reply
Hi mame it’s same message i received on my screen but skip it not select the appointment at that time I log out (after that when I will login again then show the message ( there are no currently appointments available) am facing this problem last 27 hours plz reply me back on it what should I do it’s normal or not thanks
Please elaborate
@@dsconcept20 I can see the same message on my screen ( you are approaching the maximum number of time to view this page please complete your transaction at this time ) then I log out at the same time , after an hour i login agai again then the other message on my scree ( there are currently no appointments available ) and no have any slots show there , in this situation what should we need to do plz guide us
@@greatwall2283 I understand it now. Unfortunately, nothing can be done in this situation except waiting for new slots to be added. This is not admission season so mostly like slots are not added. I would recommend to get in touch with USA consulates officers or follow their news to find out when new slots would be added. To proactive to book your slot then.
Delete card details column
How to contact you
To get in contact - Pls fill in the form forms.gle/9JMNutd1aLZbBGfV6
Hello do you provide any industry level training for data scientist
Thank you for your interest! Yes, it depends on requirements. Contact Us for more details by filling the form - forms.gle/9JMNutd1aLZbBGfV6
Thanks Mam!!
How to cancel an F1 appointment?? please help me
Hello Pradeep, May I know why do you want to cancel?
@@dsconcept20 I am looking for F2. By mistake I booked for F1
@@pradeepdeepu5729 - So sorry to know that. Canceling with refund is not possible. But, its also recommended to connect with Consultant Support Team and explain your case. They are official source of info. All the best!
@@dsconcept20 I don't want to refund. I want to schedule F2.
Thank you so much for such detailed information. I have one doubt, I have created a ds-160 account long back and now I have crossed the expiration date in the portal. Should I create a new ds-160 application or can I continue with the old one itself without bothering about the EXPIRATION DATE??
If you have already got confirmation letter after submission of DS160 you need not create a new. However, if you still want to then create a new using existing/old confirmation ID. It will copy most of the info from your form.
how to contact you\
Hello Piyush, Thanks for showing interest to connect. Please go ahead and fill the form to receive a call back. forms.gle/5rfQP8XANSjrZQxH6
Hello, I believe that it is just a simple average, not weighted average. Because if you expand the formula, it'll be: u1 = sum(sales of n1)/n1; u2 = sum(sales of n2)/n2 so, numerator = n1*sum(sales of n1)/n1 + n2*sum(sales of n2)/n2 = sum(n1) + sum(n2) weighted mean = (sum(n1) + sum(n2))/(n1+n2), which is equal to mean of whole dataset. in weighted mean, weights are assigned to each entry. please correct me if i am wrong.
Hello i make visa slot payment...not Booked visa i want to change sevis id in CGI Portal is this possible to change
Follow the same process as stated in video even for your case. All the best for interview.
Hi, i have booked my visa slot with university A details on CGI portal. After booking the slot, i got i20 of university B and I intend to join University B. What steps do i need to do? (I am yet to submit Form DS160)
Update your DS160 with new SEVIS ID. Mention to VO offer that you're changed your university. That's all. Please watch the video. It explains the same in detail. All the Best for your F1 VISA interview!
@@dsconcept20 thanks for the reply. I am not able to make any changes regarding university in the CGI portal is that ok?
@@pawansurya3279 Yes, no action required on GCI portal. Only changes in DS160 required.
@@dsconcept20 thanks a lot ❤. One last thing: where do i need to inform about the change in university? OFC center or Interview time?
@@pawansurya3279 Happy to help! To the OFC officer on biometric interview day.
i have already booked an visa interview on old university and i had decided to change university but my i20 of update uni came before 3 weeks of appointment booking will officer during ofc change my uni name in cgi??? i have filled new ds 160 after 1 day of visa booking and sevies fee is remaining
will the interviewer ask for reasons why i am changing ??
The answer is yes. All the best for your f1-visa interview!!
Hi Team, thanks for this video. I have one question. I have filled in the DS-160 form but haven't submitted it yet. I have booked the visa slots but haven't paid the Sevis fee. Now i Got an i20 which has different sevis id . But how can we update that in the CGI website ,as it doesn't show an option to update the sevis ID . It just has the option to update the DS-160 confirmation number. What should I do in this case?
Your case is similar to most other. You can do two things at this time. 1) If you haven't submitted your DS-160 then update this DS160 with new SEVIS/university details. No further action. 2) If you have already submitted DS160 then fill a new DS160 and in this form add new SEVIS/university details. For biometric interview carry this (new) DS160 confirmation page and to the VO officer mention that you have changed SEVIS/university after F1-VISA slot booking. That's all you have to do. Rest will be taken care automatically. Hope you got your all queries cleared! Happy to help! Best of luck for F1-VISA interview!!
@@dsconcept20 Thank you so much for the instant response. I have not submitted my ds-160 yet. I have updated the ds-160 with the new sevis id from University Y. But in the travel docs , I previously had a different university say X and today booked the slots. Now in the travel Docs i don't see an option to update the sevis id to Y university. It just has option for ds-160 confirmation number. Do i need to take any action now or if not ,can i submit the ds-160 with the updated university. Will that automatically get updated in us travel docs
@@shivaramakrishnan3680 No action required on CGI portal.
@@shivaramakrishnan3680 I'm in the same situation as you are. Please let me know what steps you took and how it worked out for you. Thanks !
@@caroline5978 hey Caroline, what i got to know is that you can go and update the ds-160 directly with the new sevis id and no need to worry what you have filled previously in ustraveldocs. And during the biometric day you can inform the same that initially you have applied using i20 of a different university and updated the sevis id of the new university in the ds-160 for a safer side. Hope this helps. Let me know if you need anything else
Hello I have some questions related to DS-160 and visa interview slots. I opened a DS-160 and took my visa interview date without submitting ds-160. Recently, I got married and submitted ds160 after updating my spouse information within 30 days after opening my ds160 account. Recently, I got offer letter from another university. I want to go this university with my wife. At this situation, what procedures should i follow?
Firstly, Congratulations on your marriage!! In case, fill a new ds160 form with new university details and carry this form confirmation page to biometric interview. To the VO officer mention that you have changed university after slot booking. Rest would be taken care by vo officer. The bar code given on your passport will be with new university details. Done!
Can we not change new DS160 confirmation number in CGI portal after submitting new ds160?
It depends. If you have already booked your VISA slot then you can not change DS160 confirmation Number on CGI portal else you can. In the former case, carry copy of new DS160 C. Number to F1-VISA interview and follow the steps shared in the video. Best of luck!
I haven't submitted ds160 but visa slot booked. In update profile there is option to update ds160 confirmation number but there is no option to update sevis id and university information in cgi portal. Please help me.
Plz update sevis Id and university details in ds160. This should be sufficient.
@@dsconcept20 ok
how was the interview? can you let me know what happened? did you inform the official?
Mam what about Excel
Dear @harshxsp - the modern data analytics make use of advanced tools such python, tableau , R etc. as substitution of excel. That means all excel analytical properties can be achieved using them but one can not achieve automation using excel. overall, knowing excel is good (few companies are using them religiously) however, other companies do not count them as a must to know skill but as a common known skills.
I'm not able to update my sevis, university info and ds160 in cgi, as it is not showing in update profile.
If you've already booked an appointment you can not update cgi portal details. This is where we need help from VO officers. You can only create a new DS160 form and go with this form during your visa. mention to the VO officer that you have changed the university details after VISA slot booking and you want the new university to be considered. They will take care.
@@dsconcept20 what about sevis id and university name?
@@Manoj-vg3cc Include them in new DS160 form. So this is what you have to do. Create a new ds160 form. Update new university sevis and name in this form. Carry confirmation page of this form to your interview. Inform the VO officer of the form changes.
I recommend you to watch the current video and follow the steps. The process is elaborated well and in simple form in the video. The purpose of the video is to guide students like you with queries related to university changes. Hope this helps you too.
Always happy to help!
Please like the video and subscribe the channel as a token of motivation!!
This video is very informative, Thank you.
Thank for sharing.
Thank you so much for the information! :) It has really helped me with my situation.
Glad it was helpful!
what is the tool you are using for SQL link please.
It's a great observation! Thanks for asking!! The tool used here is GCP bigquery. It is licensed product. So, sharing the link won't help. For practice I would recommend any online platform and the data that comes along the platform.
can u please suggest sql coding-solving platform for beginners?
Any online platform is good to practice.
Hello. I have my F1 VISA appointment for 4 April. My Uni start date in the i20 was 10 June. Just today my Uni told me that they have changed the start date to 12 June, and will give me a new i20. Should I change my DS160 with the new i20?
Similar situation I also want to change my i20 information how do I do it
@@gracename6941 Well you just have to fill a new ds160 with new i20. And then you have to change the ds160 code to new one in the visa appointment. But my question was do I need to change my ds160?
Yes, better do so. Don't forget to mention of the changes during biometric appointments. Plz. double check with Embassy representatives.
@@dsconcept20 Thank you.
I'm previously refused but When I am login my I'd , and i click on continue its show me visa type option but not ofc dates or conseler appointment, can u pls tell me why this happens
Dear @SunilKumar - I will recommend to call "customer care representative". They are authenticate source of any VISA related queries. Yet, in my opinion it could be some change in policies as per which once refused candidate may have barred from booking slots for a fixed duration of time.
Can you please share the dataset ..
Thanks for showing interest in the dataset however, sharing it on this platform won't work. I would recommend to use any similar dataset from Kaggle for your practice. I would strongly advice to pick up a random dataset and give an attempt to build problem statements as done in the video. Feel free to post your queries while working on it. I would be happy to help you.
Very useful information, in a very simple way. Thanks a lot.
Glad it was helpful!
Can you please provide input file?
Thanks for showing interest in the dataset however, sharing it on this platform won't work. I would recommend to use any similar dataset from Kaggle for your practice. I would strongly advice to pick up a random dataset and give an attempt to build problem statements as done in the video. Feel free to post your queries while working on it. It would be my pleasure to clear your doubts and help you progress.
Nice... Great Explanation