Vani Nalliappan has Published 130 Articles

Write a Python code to filter palindrome names in a given dataframe

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 07:09:49

485 Views

Result for printing palindrome names are −Palindrome names are:    Id   Name 0   1   bob 2   3   hannahTo solve this, we will follow the below approaches −Solution 1Define a dataframeCreate list comprehension inside set for loop to access all the values from df[‘Name’] column using ... Read More

Write a program in Python to localize Asian timezone for a given dataframe

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 07:06:49

189 Views

Assume, you have a time series and the result for localize asian time zone as, Index is: DatetimeIndex(['2020-01-05 00:30:00+05:30', '2020-01-12 00:30:00+05:30',                '2020-01-19 00:30:00+05:30', '2020-01-26 00:30:00+05:30',                '2020-02-02 00:30:00+05:30'],                dtype='datetime64[ns, Asia/Calcutta]', ... Read More

Write a program to separate date and time from the datetime column in Python Pandas

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 07:05:47

9K+ Views

Assume, you have datetime column in dataframe and the result for separating date and time as,    datetime    date          time 0 2020-01-01 07:00:00 2020-01-06 07:00:00 1 2020-01-02 07:00:00 2020-01-06 07:00:00 2 2020-01-03 07:00:00 2020-01-06 07:00:00 3 2020-01-04 07:00:00 2020-01-06 07:00:00 4 2020-01-05 07:00:00 2020-01-06 07:00:00 ... Read More

Write a program in Python to print numeric index array with sorted distinct values in a given series

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 07:01:19

59 Views

Assume, you have a series and the numberic index with sorted distinct values are −Sorted distict values - numeric array index [2 3 0 3 2 1 4] ['apple' 'kiwi' 'mango' 'orange' 'pomegranate']To solve this, we will follow the steps given below −SolutionApply pd.factorize() function inside list of non-unique elements ... Read More

Write a program in Python to perform average of rolling window size 3 calculation in a given dataframe

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 07:00:07

140 Views

Assume, you have a dataframe and the result for rolling window size 3 calculation is, Average of rolling window is:    Id Age  Mark 0 NaN NaN  NaN 1 1.5 12.0 85.0 2 2.5 13.0 80.0 3 3.5 13.5 82.5 4 4.5 31.5 90.0 5 5.5 60.0 87.5To solve this, ... Read More

Write a program in Python to slice substrings from each element in a given series

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 06:58:31

78 Views

Assume, you have a series and the result for slicing substrings from each element in series as, 0    Ap 1    Oa 2    Mn 3    KwTo solve this, we will follow the below approaches −Solution 1Define a seriesApply str.slice function inside start=0, stop-4 and step=2 to slice ... Read More

Write a Python function to split the string based on delimiter and convert to series

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 06:55:36

478 Views

The result for splitting the string with ’' delimiter and convert to series as, 0    apple 1    orange 2    mango 3    kiwiTo solve this, we will follow the below approach −Solution 1define a function split_str() which accepts two arguments string and delimiterCreate s.split() function inside delimiter ... Read More

Write a program in Python to print the first and last three days from a given time series data

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 06:52:25

97 Views

Assume, you have time series and the result for the first and last three days from the given series as, first three days: 2020-01-01    Chennai 2020-01-03    Delhi Freq: 2D, dtype: object last three days: 2020-01-07    Pune 2020-01-09    Kolkata Freq: 2D, dtype: objectTo solve this, we will ... Read More

Write a program in Python to generate a random array of 30 elements from 1 to 100 and calculate maximum by minimum of each row in a dataframe

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 06:51:25

73 Views

Result for generating dataframe maximum by a minimum of each row is0    43.000000 1    1.911111 2    2.405405 3    20.000000 4    7.727273 5    6.333333To solve this, we will follow the steps given below −Solution 1Define a dataframe with size of 30 random elements from 1 ... Read More

Write a Python code to find the second lowest value in each column in a given dataframe

Vani Nalliappan

Vani Nalliappan

Updated on 25-Feb-2021 06:49:42

797 Views

Assume, you have a dataframe and the result for second lowest value in each column as, Id       2 Salary 30000 Age    23To solve this, we will follow the steps given below −SolutionDefine a dataframeSet df.apply() function inside create lambda function and set the variable like x ... Read More

Previous 1 ... 3 4 5 6 7 ... 13 Next
Advertisements