TechOnespot

All computer course for class 9th to 12th with proper practical and theory .........

Search This Blog

Home Page

Class 6th
Class 7th
Class 8th
Class 9th
Class 10th
About Us
Contact Us
Privacy Policy

More…

Posts

Showing posts with the label Querying and SQL Function

Show all

ads1

Querying and SQL Function

April 10, 2022

Querying and SQL Function NCERT Sumita Arora

Get link
Facebook
X
Pinterest
Email
Other Apps

ads2

Labels

# Write a Python program to enter base and height of a triangle and find its area.
# Write a Python program to enter temperature in Fahrenheit and convert to Celsius
#1. Write a Python program to enter two numbers and find their sum.
#2. Write a Java program to find maximum between three numbers.
#Python basic
#Python fundamental
#Write a Python program to calculate area of an equilateral triangle.
#Write a Python program to convert days into years
#Write a Python program to enter any number and calculate its square root.
#Write a Python program to enter length and breadth of a rectangle and find its area.

#Write a Python program to enter length and breadth of a rectangle and find its perimeter.
#Write a Python program to enter length in centimeter and convert it into meter and kilometer.
#Write a Python program to enter marks of five subjects and calculate total
#Write a Python program to enter P
#Write a Python program to enter temperature in Celsius and convert it into Fahrenheit.
#Write a Python program to enter two angles of a triangle and find the third angle.
#Write a Python program to find power of any number x ^ y.
#Write a Python program to perform input/output of all basic data types.
1. Create a pandas series from a dictionary of values and an ndarray.
1. Write a C program to enter two numbers and find their sum.
1. Write a Java program to print all natural numbers from 1 to n. - using while loop
1. Write a Python program to find maximum between two numbers.
1.Write a Java program to find maximum between two numbers.
10. Write a Java program to count number of digits in a number.
10. Write a Java program to input marks of five subjects Physics
10.Write Pandas Program to filter out rows such as Duplicate rows.
10th Chapter - 4 List and Table in Html
11. Write a Java program to find first and last digit of a number.
11. Write a C program to enter P
11. Write a Java program to input basic salary of an employee and calculate its Gross salary according to following:
11. Write a program to generate a series of float numbers from 41.0 to 60.0 with an increment of 2.5 each.
12. Write a C program to enter base and height of a triangle and find its area.
12. Write a Java program to input electricity unit charges and calculate total electricity bill according to the given condition:
12.Create a data frame based on e-commerce data and generate descriptive statistics (mean
12.Write a Java program to find sum of first and last digit of a number.
12.Write a program to generate a series of 10 numbers with a scalar value of 44.
13. Create a data frame for examination results and display row labels
13. Write a C program to find maximum between two numbers.
13.Write a Java program to swap first and last digits of a number.
14. Write a Java program to calculate sum of digits of a number.
15. Write a Java program to calculate product of digits of a number.
15. Write a C program to check whether a number is negative
16. Write a C program to check whether a number is divisible by 5 and 11 or not.
17. Write a C program to check whether a number is even or odd.
17.Importing and exporting data between pandas and CSV file.
18. Write a C program to check whether a year is leap year or not.
18..Read the ‘Student.csv’ to create a data frame and do the following operation:
19. Write a Java program to print all ASCII character with their values.
19. Write a C program to input any alphabet and check whether it is vowel or consonant.
2. Write a C program to enter two numbers and perform all arithmetic operations.
2. Write a C program to find maximum between three numbers.
2. Write a program to generate a series of 10 numbers with a scalar value of 44.
2. Write a program to plot a bar chart in python to display the result of a school for five consecutive years.
2. Write a Python program to find maximum between three numbers.
2.Write a Pandas program to perform arithmetic operations on two Pandas Series.
2.Write a program to plot a bar chart in python to display the result of a school for five consecutive years.
20. Write a C program to count total number of notes in given amount.
21. Write a C program to calculate profit or loss.
22. Locate the 3 largest values in a data frame.
22. Write a C program to input marks of five subjects Physics
23. Write a C program to input basic salary of an employee and calculate its Gross salary according to following:
23.Given a Series
24.Write a C program to input electricity unit charges and calculate total electricity bill according to the given condition:
26.Replace all negative values in a data frame with a 0.
27.Replace all missing values in a data frame with a 999 .
3. Write a C program to enter length and breadth of a rectangle and find its perimeter.
3. Write a Java program to check whether a number is negative
3. Write a Java program to print all alphabets from a to z. - using while loop
3. Write a Pandas program to add some data to an existing Series.
3. Write a Python program to check whether a number is negative
4. Write a C program to enter length and breadth of a rectangle and find its area.
4. Write a Pandas program to select the rows where the percentage greater than 70.
5. Write a C program to enter radius of a circle and find its diameter
5. Write a Pandas program to select the rows the percentage is between 70 and 90 .
5.Plot the following data on a line chart and customize the chart according to the below-given instructions:
6. Write a C program to enter length in centimeter and convert it into meter and kilometer.
6. Write a Java program to check whether a year is leap year or not.
6. Write a Python program to check whether a year is leap year or not.
6.Create a dataframe and print it along with their index using iteritems().
7. Create a dataframe and iterate them over rows.
7. Write a C program to enter temperature in Celsius and convert it into Fahrenheit.
7. Write a Java program to find sum of all even numbers between 1 to n.
7. Write a Java program to input any alphabet and check whether it is vowel or consonant.
7.Read the ‘Student_result.csv’ to create a data frame and do the following operation:
7.Write a Pandas program to join the two given dataframes along rows and assign all data.
8. Write a C program to enter temperature in Fahrenheit and convert to Celsius.
8. Write a Java program to count total number of notes in given amount.
8. Write a Java program to find sum of all odd numbers between 1 to n.
8.Write a Pandas program to join the two given dataframes along columns and assign all data.
9. Write a Java program to print multiplication table of any number.
9. Write a C program to convert days into years
9. Write a Java program to calculate profit or loss.
9.Write a Java program to print multiplication table of any number.
9.Write a Pandas program to append a list of dictionaries or series to an existing DataFrame and display the combined data.
analyses the performance of the students on #different parameters
and expenditure. Group the rows by the category and print the total expenditure per category.
and variance
average and percentage
average and percentage.
Basic Ubuntu Linux Commands
BCA
BCA Sem 4 Java
Biology
C Language Tutorial
C Program Tutorial
CH-3 Poverty as Challenge
Chapter - 2 Cultural Heritage of India : Traditional Handicraft and Fine Arts
Chapter - 5 Introduction to Operating System
Chapter - 5 Using Mail Merge
Chapter - 7 Introducation to Ubuntu Linux GUI
Chapter - 9 Introduction to Word Processing
Chapter -1 Heritage of INDIA
Chapter :- 1 Development
Chapter :- 1 Python Pandas - I
Chapter :- 1 Resources and Development
Chapter :- 1 The Rise of Nationalism in Europe
Chapter :- 2 Adding Graphics in a Document
Chapter :- 2 Sectors of the Indian Economy
Chapter :- 7 Vim Editor and Basic Scripting
Chapter 1 :- Power Sharing
Chapter 1 :- Resources and Development
Chapter 1 :- The Story of Village Palampur
Chapter 10 :- Editing and Formatting Documents
Chapter 11 :- Tables and Mail Merge
Chapter 2 :- Federalism
Chapter 2 physics feature
Chapter 3 :- Input and Output Devices
Chapter 4 :- Agriculture
Chapter 4 :- Memory
Chapter 4 Using a Table of Content
Chapter 6 - Introduction to Ubuntu Linux
chapter-13 Other useful free tools and services
Chemistry
circumference and area.
circumference and area.. BCA
Class :- 12th Chapter - 4 Introduction to E-Commerce
class 10
Class 10 ch-5 Introduction to Calc
class 10 Chapter :- 13 Decision Structures
class 10 computer cbse
class 10th
Class 10th (CBSE) Economics Chapter :- 1 Development
Class 10th CBSE Chapter -1 Applying Styles in a Document
Class 10th Chapter
Class 10th Chapter - 9 Promblem and Promblem Solving
Class 10th Chapter :- 14 Loop Control Structures
Class 10th chapter :- 15 ARRAYS
Class 10th Chapter :- 16 Function
Class 10th Chapter 10 Introduction to C language
Class 10th Chapter 12 Using I/O Operations
class 10th chapter 3 Handling Images in HTML
Class 10th Chapter 6 Data Editing and Formating in Calc
Class 10th Chapter 7 Functions in Calc
Class 10th Chapter 8 Charts in Calc
class 10th Computer
Class 10th Computer HTML WORKSHEET
Class 10th Data Types
class 10th gseb
Class 10th gseb Chapter -1
class 10th gseb computer
Class 10th GSEB Social Science Chapter :-1 Heritage of India
class 11
Class 11 Chapter 1 :- Introduction to Multimedia
Class 11 Chapter 2 :- Animation Tool: synfig
Class 11th CBSE Chapter :- 2 Getting Stared with Python
Class 11th Chapter - 5 Flow of Control
Class 11th Chapter -4 Data Handling
Class 11th Chapter -9 Intdroductin to database management System
Class 11th Chapter :- 1 COMPUTER SYSTEM
Class 11th Chapter :- 10 Working with table
Class 11th Chapter 10th Emerging Trends.
Class 11th Chapter 13 Current Trends and Technologies
Class 11th Chapter 3 :- Python Fundamental
Class 11th Chapter 6 :- List Manipulation
Class 11th Chapter 7 :- Dictionaries
Class 11th Chapter 8 DATABASE CONCEPT
Class 11th Chapter 9th Structure Query Language (SQL)
Class 11th Chapter-6 Basic Ubuntu Linux Commands
Class 11th Information Practice Multiple Choice Question (MCQ)
class 12
class 12 Gseb
Class 12th
Class 12th Ch-6 Object Oriented Concept (GSEB)
Class 12th Chapter :- 11 Societal Impacts
Class 12th Chapter :- 7
Class 12th Chapter :- 7 Write a JAVA program to convert days into years
Class 12th Chapter :- 7 Write a Java program to enter length in centimeter and convert it into meter and kilometer.
Class 12th Chapter :- 7 Write a JAVA program to enter P
Class 12th Chapter :- 7Write a Java program to enter radius of a circle and find its diameter
Class 12th Chapter 9 Working with Array and String
class 12th Chapter-8 Classes and object in Java.
Class 12th Chpater -7 Java Basics
class 12th gseb
class 12th gseb computer
class 12th MCQ
Class 12thJava Basics
class 9 Social
Class 9th CBSE Economics Chapter :-1 The Village Palampur
Class 9th Civics Chapter :- 1 What is democracy ? Why Democracy
Class 9th Social Science Chapter 2 - Physical Features of India.
class10 computer
class6th CBSE
Class9th STGP Computer Chapter :- 9 Mail Merge
column labels data types of each column and the dimensions.
Computer System
computer_9
Create a data frame for examination results and display row labels
Create a Data Frame quarterly sales where each row contains the item category
Data Handling Using Pandas I
digit or special character.
e.g subject wise or class wise.
Economics
Economics 9_Social
Find the sum of each column
Given the school result data
GSEB
History and Evolution of Computers
How to Download and Install Oracle 10g in Window System
How to Download and Install Python in your Window System
HTML
INPUT
Introduction to Calc
Introduction to computers
item name
Java
java basic
Java Programming
Kompozer
List
m-commerce
Mathematics and Computer. Calculate percentage and grade according to following:
Mathematics and Computer. Calculate percentage and grade according to following:
MCQ
median
mode
Multimedia
MySQL SQL Revision Tour
Open office
OPERATING SYSTEM SOFTWARE WINDOWS 7
Operators and Expression in C Language
or find the column with the lowest mean.
OUTPUT and STORAGE DEVICES
positive or zero.
Pratyush Garments has recorded the following data into their register for their income from cotton clothes and jeans. Plot them on the line chart.
print all the elements that are above the 75th percentile.
Python class 11th Information Practice
quartile
Querying and SQL Function
R and calculate Simple Interest
R and calculate Simple Interest.
Read the ‘Student.csv’ to create a data frame and do the following operation:
social10
Storage Devices and Data Representation
Synfig
T
Table
Use above dataframe and do the following:
weeks and days.
Write a C program to enter length and breadth of a rectangle and find its area.
Write a C program to enter length in centimeter and convert it into meter and kilometer.
Write a C program to enter radius of a circle and find its diameter
Write a C program to enter two numbers and find their sum
Write a C program to enter two numbers and perform all arithmetic operations
Write a C program to enter two numbers and perform all arithmetic operations.
Write a JAVA program to enter marks of five subjects and calculate total
Write a java program to check whether a number is Armstrong number or not.
Write a Java program to check whether a number is divisible by 5 and 11 or not.
Write a java program to check whether a number is palindrome or not.
Write a Java program to create Simple Calculator using switch case.
Write a Java program to enter base and height of a triangle and find its area.
Write a Java program to enter length and breadth of a rectangle and find its area. BCA
Write a Java program to enter length and breadth of a rectangle and find its perimeter.
Write a Java program to enter temperature in Celsius and convert it into Fahrenheit. BCA
Write a Java program to enter temperature in Fahrenheit and convert to Celsius
Write a Java Program to enter two numbers and find their sum
Write a Java program to find sum of all natural numbers between 1 to n.
Write a Java program to print all even numbers between 1 to 100. - using while loop.
Write a Java program to print all natural numbers in reverse (from n to 1). - using while loop
Write a Java program to print all odd number between 1 to 100.
Write a Java program to Print Hello World
Write a Pandas program to change the percentage in a given row by the user.
Write a Python program to calculate profit or loss.
Write a Python program to check whether a character is alphabet or not.
Write a Python program to check whether a number is divisible by 5 and 11 or not.
Write a Python program to check whether a number is even or odd.
Write a Python program to count total number of notes in given amount.
Write a Python program to enter radius of a circle and find its diameter
Write a Python program to enter two numbers and perform all arithmetic operations.
Write a Python program to input any alphabet and check whether it is vowel or consonant.
Write a Python program to input any character and check whether it is alphabet
Write a Python program to input basic salary of an employee and calculate its Gross salary according to following:
Write a Python program to input electricity unit charges and calculate total electricity bill according to the given condition:
Write a Python program to input marks of five subjects Physics
Write a Python Program to Swap Between two number

Show more Show less

Report Abuse

Powered by Blogger