Vani Nalliappan has Published 130 Articles

Write a Python program to sort a given DataFrame by name column in descending order

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 07:21:58

494 Views

Input −Assume, sample DataFrame is,   Id Name 0 1 Adam 1 2 Michael 2 3 David 3 4 Jack 4 5 PeterOutput −After, sorting the elements in descending order as,   Id Name 4 5 Peter 1 2 Michael 3 4 Jack 2 3 David 0 1 AdamSolutionTo solve ... Read More

Write a Python function which accepts DataFrame Age, Salary columns second, third and fourth rows as input and find the mean, product of values

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 07:19:56

419 Views

Input −Assume, sample DataFrame is,  Id Age  salary 0 1 27   40000 1 2 22   25000 2 3 25   40000 3 4 23   35000 4 5 24   30000 5 6 32   30000 6 7 30   50000 7 8 28   20000 8 9 ... Read More

Write a Python program to count the total number of ages between 20 to 30 in a DataFrame

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 07:15:41

792 Views

Input −Assume, you have a DataFrame,  Id Age 0 1 21 1 2 23 2 3 32 3 4 35 4 5 18Output −Total number of age between 20 to 30 is 2.SolutionTo solve this, we will follow the below approaches.Define a DataFrameSet the DataFrame Age column between 20, 30. ... Read More

Write a program in Python to print the ‘A’ grade students’ names from a DataFrame

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 07:12:02

480 Views

Input −Assume, you have DataFrame,  Id  Name Grade 0 1 stud1   A 1 2 stud2   B 2 3 stud3   C 3 4 stud4   A 4 5 stud5   AOutput −And the result for ‘A’ grade students name, 0    stud1 3    stud4 4    stud5SolutionTo ... Read More

Write a program in Python to find the minimum age of an employee id and salary in a given DataFrame

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 07:04:25

745 Views

Input −Assume, you have a DataFrameDataFrame is  Id    Age   Salary 0 1    27    40000 1 2    22    25000 2 3    25    40000 3 4    23    35000 4 5    24    30000 5 6    32    30000 6 7 ... Read More

Write a program in Python to find the maximum length of a string in a given Series

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 07:02:12

467 Views

Input −Assume, we have a Series like this, [“one”, “two”, “eleven”, “pomegranates”, “three”] and the maximum length of the string is “Pomegranates”SolutionTo solve this, we will follow the below approaches.Define a SeriesSet the initial value of a maxlen is 0Set the “maxstr” value is initially empty string.Create a for loop ... Read More

Write a Python program to find the maximum value from first four rows in a given series

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 06:58:26

80 Views

Input −Assume, you have a Series, 0    11 1    12 2    66 3    24 4    80 5    40 6    28 7    50Output −Maximum value for first four row is 66.SolutionTo solve this, we will follow the steps given below −Define a SeriesSet ... Read More

Write a program in Python to round all the elements in a given series

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 06:57:19

55 Views

Input −Assume, you have a Series, 0    1.3 1    2.6 2    3.9 3    4.8 4    5.6Output −0    1.0 1    3.0 2    4.0 3    5.0 4    6.0Solution 1Define a SeriesCreate an empty list. Set the for loop to iter the data. ... Read More

How to print the days in a given month using Python?

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 06:49:57

262 Views

Input −Assume, you have date series to find the number of days in a month.SolutionTo solve this, we will follow the steps given below −Define date seriesSet date_range value as 2020-02-10.find the number of days in a month using Series.dt.daysinmonthExampleLet us see the complete implementation to get a better understanding ... Read More

Write a program in Python to print the day of the year in a given date series

Vani Nalliappan

Vani Nalliappan

Updated on 24-Feb-2021 06:49:11

215 Views

Input −Assume, you have a series and find the day of the year from a given specific range of dates.SolutionTo solve this, we will follow the below approaches.Define a SeriesSet date_range as ‘2020-01-10’ with five periods. It is defined below, pd.date_range('2020-01-10', periods=5)Find the day using Series.dt.dayofyear.ExampleLet us see the complete ... Read More

Advertisements