CodingInPy Official
26.3K subscribers
111 photos
15 files
279 links
Python, SQL, Programming - 30k

Ads / Promotions Contact: @Nssbcoder
Download Telegram
FLIPKART is hiring via WiRED 8.0

Hiring Opportunities
โž•Full-time roles: MT & LR | CTC: INR 26-35 LPA
โž•Internship: Stipend of INR *1.2 lac/month
Goodies & Winner Kits worth INR 3 Lakh

Application Link - https://oia.link/cf86v

Eligibility: MBA Students

Application Deadline : 2nd August, 2024

Apply Now!
๐Ÿ‘4๐Ÿ”ฅ1
KPMG is hiring for the role of Technology Delivery Center Assistant Manager!

Expected salary: INR 15 - 20 LPA (via Glassdoor)

Link: https://openinapp.net/l9ils
๐Ÿ‘2โค1
GE is hiring for the role of Digital Leadership Development Program Associate!

Expected salary: INR 4 - 8 LPA (via Glassdoor)

Link: https://openinapp.link/h044s
๐Ÿ‘2
Siemens is Hiring Software Developers
Experience: Freshers
Link: https://openinapp.link/1l8ad

PayPal is Hiring Data Analysts
Experience: 2 to 5 years
Link: https://openinapp.link/pahr5

Citi is Hiring Python Developers
Experience: 2 to 5 years
Link: https://openinapp.link/9p8uf
๐Ÿ‘6โค1๐Ÿฅฐ1
Apply for Jobs & Share to your Friends ๐Ÿ’ผ

For Freshers

Hitachi is hiring for the role of Project Engineer!
Link: https://openinapp.link/bwthg

Volvo Group is hiring for role of Supplier Quality Engineer!
Link: https://openinapp.link/5t57h

Flipkart is Hiring SDE1 & SDE Interns
Link: https://openinapp.link/l7g4j
๐Ÿ‘9โค1
๐Ÿ‘6โค5
Tata Group is hiring interns!
Participate in Tata Crucible Campus Quiz

Rewards:
* Internship with the Tata Group
* Cash Prize Pool of INR 2.5 lakhs
* Luxury Holiday at Taj hotels

Application Link- https://unstop.com/quiz/tata-crucible-campus-quiz-2024-tata-crucible-990689?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=TATACrucible02082024&ref=Codinginpy

Eligibility: Open to all students

Apply now!
๐Ÿ‘5โค2
Meesho is hiring for the role of Software Development Engineer I - Data!

Expected salary: INR 17 - 21 LPA (via Glassdoor)

Link: https://unstop.com/jobs/software-development-engineer-i-data-meesho-1100922?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=MEESHO02082024&ref=Codinginpy
๐Ÿ‘6โค2
Genpact is hiring for the role of Process Associate-Developer Support Engineering!

Expected salary: INR 3 - 6 LPA (via Glassdoor)

Link: https://openinapp.net/bghwp
๐Ÿ‘1
Data Analyst Interview QnA

1. Find avg of salaries department wise from table.

Answer-
SELECT department_id, AVG(salary) AS avg_salary
FROM employees
GROUP BY department_id;


2. What does Filter context in DAX mean?

Answer - Filter context in DAX refers to the subset of data that is actively being used in the calculation of a measure or in the evaluation of an expression. This context is determined by filters on the dashboard items like slicers, visuals, and filters pane which restrict the data being processed.

3. Explain how to implement Row-Level Security (RLS) in Power BI.

Answer - Row-Level Security (RLS) in Power BI can be implemented by:

- Creating roles within the Power BI service.
- Defining DAX expressions that specify the data each role can access.
- Assigning users to these roles either in Power BI or dynamically through AD group membership.

4. Create a dictionary, add elements to it, modify an element, and then print the dictionary in alphabetical order of keys.

Answer -
d = {'apple': 2, 'banana': 5}
d['orange'] = 3 # Add element
d['apple'] = 4 # Modify element
sorted_d = dict(sorted(d.items())) # Sort dictionary
print(sorted_d)


5. Find and print duplicate values in a list of assorted numbers, along with the number of times each value is repeated.

Answer -
from collections import Counter

numbers = [1, 2, 2, 3, 4, 5, 1, 6, 7, 3, 8, 1]
count = Counter(numbers)
duplicates = {k: v for k, v in count.items() if v > 1}
print(duplicates)


Like โค๏ธ & Share the post if you want me to post more similar content. ๐Ÿ˜Š
๐Ÿ‘16โค8๐Ÿ‘ป1
S&P Global is hiring for the role of Software Development Engineer 1!

Expected salary: INR 7 - 19 LPA via Glassdoor)

Link: https://openinapp.link/3e7kt
๐Ÿ‘4โค1
Cognizant is hiring for the role of Associate - Projects!

Expected salary: INR 8 - 14 LPA (via Glassdoor)

Link: https://unstop.com/jobs/associate-projects-cognizant-1119972?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Cognizant13082024&ref=Codinginpy
๐Ÿ‘5
Rebel Foods is hiring!

1. PPI Offer:- CTC upto 20 Lakhs
2. Cash Prize Pool of INR 1.5 Lakhs

Application Link: https://unstop.com/competitions/rebel-foods-eatsure-cloud-2024-rebel-foods-1116221?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=RebelFood13082024&ref=Codinginpy

Eligibility: Open to all

Apply Now!
๐Ÿ‘3โค1
Genpact is hiring for the role of Associate-Procurement!

Expected salary: INR 3 - 6 LPA via Glassdoor)

Link: https://unstop.com/jobs/associate-procurement-genpact-1116562?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Genpact12082024&ref=Codinginpy
๐Ÿ‘3โค1
CodingInPy Official pinned ยซ120+ Python Projects with Source Codes ๐Ÿ”ฝ https://drive.google.com/drive/folders/1TvjOQx_XfxARi8qNtDwpZNwmcor5lJW_?usp=share_link WhatsApp: https://whatsapp.com/channel/0029VacdBsc0lwgnyDoW9a1Z Instagram: https://www.instagram.com/codinginpy?igsh=MXVpcnppNTg5Zm5hcA==โ€ฆยป
BlackRock is hiring for the role of Applied Analytics Associate!

Expected salary: INR 7 - 11 LPA via Glassdoor)

Link: https://unstop.com/jobs/applied-analytics-associate-blackrock-1116431?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=BlackRock14082024&ref=Codinginpy