Search & Filtering
Create a dataframe by using the dataset [tipsnew.csv] and perform the
following operations
a) Print the day value when the value of total_bill is maximum and
minimum.
b) Retrieve all the rows from dataframe when the value of tip is more
than 3.0 and less than 5.0
c) Print the time of the meal and gender of the person who paid the tip
more than 5.0
d) Select and display last 10 rows from the dataframe when customer
smoking habbit is ‘yes’
e) Create the newdataframe(ndf) from original dataframe(df)
containing all rows and the following columns [total_bill
tip, size].
Sort and display all values of column tip in ascendending order
Discuss different ways of creating a dataframe in python programming
languages using panda library. Justify your answer with the help of
suitable example
With the help panda library create a dataframe using the concept of
dictionary of lists where Keys and Values of dictionary take the data as
mention above in the figure and perform the following operations
a) Print All columns name from the dataframe and change the
b) Display top 7 and bottom 7 rows of first 3 and last 3 columns
c) Write the python code statement to print the value “21-Jan-12” from
dataframe.
d) Write the python code statement to print the values 2nd,4th ,6th , 8th and
10th row for the column “No of Hours”
e) Display the total sum of column total_payout
Python code to input 10 values and get the average temperature of a patient. if the average temperature value is in between 97 Fahrenheit and 99 Fahrenheit then display the message “Your body temperature is normal...”. If it is more than 100.40 Fahrenheit then display the message “You have a fever caused by an infection or illness...”.
Workers of Maunlad corp. have a regular working hours of 40 hours per week and
are paid with an hourly rate of P150 per hour. However, if a worker rendered more
than 40 hours in a week the excess hours are paid 75% more. Write a program that
inputs the number of hours rendered by a worker in 1 week then display his/her
salary.
Create a dataframe by using the dataset [tipsnew.csv] and perform the
following operations
a) Print the day value when the value of total_bill is maximum and
minimum.
b) Retrieve all the rows from dataframe when the value of tip is more
than 3.0 and less than 5.0
c) Print the time of the meal and gender of the person who paid the tip
more than 5.0
d) Select and display last 10 rows from the dataframe when customer
smoking habbit is ‘yes’
e) Create the newdataframe(ndf) from original dataframe(df)
containing all rows and the following columns [total_bill tip, size].
Sort and display all values of column tip in ascendending order.
Discuss different ways of creating a dataframe in python programming
languages using panda library. Justify your answer with the help of
suitable example.
Program to get the count of notes and shows the denomination
Please correct the error. There are syntax errors, logical errors and runtime errors.
1.
if x == y:
print('Equal')
2.
x = 'hello'
y = ['hello']
if x == y:
print('Equal')3.
x = True
while x:
for x in list(range(0,10)):
print(x)4.
myfunction(x, y):
return x + y
else:
print("Hello!")
if mark >= 50
print("You passed!")
if arriving:
print("Hi!")
esle:
print("Bye!")
if flag:
print("Flag is set!")Thank you for the help!
Create a dataframe by using the dataset [TITANIC.csv] and perform the following operations
i) Print the value of ‘PassengerId’ when the value of Fare is maximum and minimum.
ii) Retrieve all the rows from dataframe when the value of age of the traveller is lies between 40 and 50.
iii) Retrieve the names and gender of all the persons who was survived after the ship fell into the sea.
iv) Select and display last 10 rows from the dataframe when Fare is more than 100 and less than 200’
v) Create the newdataframe(ndf) from original dataframe(df) containing all rows and the following columns [name, ticket,’Fare]. Sort and display all values of column Name in descending order
SOLVE THIS USING PYTHON
