Informatics Practices
Write a Python Program to create a Pandas Series as shown below using a dictionary. Note that the left column indicates the indices and the right column displays the data.
| Russia | Moscow |
| Hungary | Budapest |
| Switzerland | Bern |
Related Questions
Ayesha's family is replacing their old computer with a new one. They decide to throw the old computer in a nearby empty field/plot.
I. Explain any one potential environmental hazard associated with improper e-waste disposal.
II. Suggest one responsible way to Ayesha's family for proper disposal of their old computer.
III. Describe the importance of recycling in e-waste management.
Write a Python program to create the following DataFrame using a list of dictionaries.
No Product Price 0 Laptop 60000 1 Desktop 45000 2 Monitor 15000 3 Tablet 30000 I. Write an SQL statement to create a table named STUDENTS, with the following specifications:
Column Name Data Type Key StudentID Numeric Primary Key FirstName Varchar(20) LastName Varchar(10) DateOfBirth Date Percentage Float(10, 2) II. Write SQL Query to insert the following data in the Students Table
1, Supriya, Singh, 2010-08-18, 75.5
Consider the following tables:
Table 1:
EMPLOYEE which stores Employee ID (EMP_ID), Employee Name (EMP_NAME), Employee City (EMP_CITY)
Table 2:
PAYROLL which stores Employee ID (EMP_ID), Department (DEPARTMENT), Designation (DESIGNATION), and Salary (SALARY) for various employees.
Note: Attribute names are written within brackets.
Table: EMPLOYEE
EMP_ID EMP_NAME EMP_CITY 1 ABHINAV AGRA 2 KABIR FARIDABAD 3 ESHA NOIDA 4 PAUL SEOUL 5 VICTORIA LONDON Table: PAYROLL
EMP_ID DEPARTMENT DESIGNATION SALARY 1 SALES MANAGER 75000 2 SALES ASSOCIATE 50000 3 ENGINEERING MANAGER 95000 4 ENGINEERING ENGINEER 70000 5 MARKETING MANAGER 65000 Write appropriate SQL queries for the following:
I. Display department-wise average Salary.
II. List all designations in the decreasing order of Salary.
III. Display employee name along with their corresponding departments.