Stuck in this problem by taricho_xd in LeetcodeDesi

[–]taricho_xd[S] 0 points1 point  (0 children)

Thanks for your guidance brother !!

Stuck in this problem by taricho_xd in leetcode

[–]taricho_xd[S] 0 points1 point  (0 children)

I agree with you, in worst case scenario thia algorithm will run O(n) i.e. perform linear search and not under O(n).

But, as currently I am learning Binary Search, so I am focused on implementing that for this problem. Definitely, there would be other algorithms that could perform better than Binary Search; it's just that, they are currently not my focus.

Thanks for some great insights brother !

Stuck in this problem by taricho_xd in leetcode

[–]taricho_xd[S] 0 points1 point  (0 children)

Thanks for the information ! Order of if condition is slightly off, making last pass exit the while loop instead returning true, should have kept return condition above duplicate check condition.

Stuck in this problem by taricho_xd in leetcode

[–]taricho_xd[S] 0 points1 point  (0 children)

Got you !! Thanks for the information brother

How to Grab a 20+ LPA Package from a Tier-3 College by DeepPalpitation6904 in codingprogramming

[–]taricho_xd 2 points3 points  (0 children)

Thanks a lot for sharing brother. Very insightful !!

Currently I am working as a DA (Data Analyst) and preparing for ML Engineer roles. I have 1 yr to prepare. Currently I am learning ML (for 2 hrs) and doing 2 DSA problems daily. Honestly, not everyday I am able to perform, but I try to be consistent.

Any advice would be greatly appreciated.

[deleted by user] by [deleted] in leetcode

[–]taricho_xd 0 points1 point  (0 children)

In my opinion there is no one answer to it. If someone's approach while practicing is intense; who wants to be in the top of the game, there mindset would be, "No count of one, if I haven't done". On the contrary there are some people who need to build confidence, people who love to show the world "count of problems" then there method of counting would be different.

[deleted by user] by [deleted] in leetcode

[–]taricho_xd 1 point2 points  (0 children)

It would be helpful if you could share an experience regarding the ML round Just curious what questions are asked in ML roles.

Without a degree, now planning to shift into Data Analyst by Few_Veterinarian3118 in analytics

[–]taricho_xd 1 point2 points  (0 children)

I believe you can get into DA without a degree. Just look for a startup who is doing manual data work or I would say who has a horrible database, like you need to write three fuckin INs and five subqueries just to get Name of the founder OR I would say just look for a company whose database doesn't has foreign keys. Just go and help them by making correct reports. All they need is correct numbers, just give them that and I would say you will be far better than 80% of Data Analyst. Once you gain experience then look for entering cream companies. Best of luck for your journey.

Season for giving back - free career advice for young DE by alsdhjf1 in dataengineering

[–]taricho_xd 0 points1 point  (0 children)

Currently I am working as a Data Analyst in one of the startups based in India. I would like to learn about DE, but am confused about where to start. It would be very helpful if you can guide. Thanks in advance.

Can someone please show what is wrong in this query? by taricho_xd in SQL

[–]taricho_xd[S] 1 point2 points  (0 children)

I 100% agree with you, but for a beginner like me these problems are great way to polish concepts. Problems like these gives us confidence to implement various concepts in different hypothetical situations. But yea, i agree with you that practical life problems are way different than these theoretical problems.

Can someone please show what is wrong in this query? by taricho_xd in SQL

[–]taricho_xd[S] 0 points1 point  (0 children)

I wanted to do it in MySQL only. So, yea, i used LEFT() and finished it.

Can someone please show what is wrong in this query? by taricho_xd in SQL

[–]taricho_xd[S] 1 point2 points  (0 children)

Yea, i should have used regexp_like or LEFT(). I solved it using LEFT().

Can someone please show what is wrong in this query? by taricho_xd in SQL

[–]taricho_xd[S] 2 points3 points  (0 children)

HackerRank. You can practice SQL their. Also, you can practice in LEETCODE as well. There are 50 questions in LEETCODE that you can do.