- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Vani Nalliappan has Published 130 Articles
Vani Nalliappan
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
Vani Nalliappan
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
Vani Nalliappan
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
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
Vani Nalliappan
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
Vani Nalliappan
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
Vani Nalliappan
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
Vani Nalliappan
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
Vani Nalliappan
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
Vani Nalliappan
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