Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Gireesha Devara
Page 14 of 18
How to remove rows in a Pandas series with duplicate indices?
By using the duplicated() method in the pandas series constructor we can easily identify the duplicate values in the index of a series object. The method duplicated() is used to identify the duplicate values in a series object.The duplicated() method will return a series with boolean values. Boolean value False indicates single occurrence values mean unique values. The duplicated values are indicated with boolean value True.Example 1Here we will see how we can delete the rows of a series object with duplicate indices.# importing pandas package import pandas as pd #create series series = pd.Series(["a", "b", "c", "d", "e"], ...
Read MoreWhat is the use of the series.duplicated() method in pandas?
Finding the duplicate values in an object is a very common task in the data analysis process. In pandas, we have a function called duplicated() which is used to identify the duplicate values.For a pandas series object, the duplicated() method will return a series with boolean values. True indicates duplicate values only for the last occurrence values or the first occurrence values or it may indicate all the duplicate values.The duplicated() method has a parameter called “keep” which is used to treat the duplicate values differently. The default behavior of this parameter is “first” which means it marks all the ...
Read MoreWhat are the ways to extract features from a DateTime variable using pandas?
Reading and extracting valid information from a DateTime object is a very important task in data analysis. The pandas package provides some useful tools to perform feature extracting from a DateTime object.In pandas, the series.dt() method is used to access the components like years, months, days, etc., from a given time series.The series.dt() method has some attributes to extract the year, month, quarter, and day features. In the examples given below, we will use some of these attributes to extract features.Example 1You can see that we have created a pandas series with 10 different timestamps. Then, we accessed only the ...
Read MoreHow does the keep parameter work in the pandas series.drop_duplicates() method?
The drop_duplicate() method in the pandas series constructor is used to remove the duplicate values from a series object. This method cleans the duplicate values and returns a series with modified rows, and it won’t alter the original series object. Instead, it will return a new one.One of the important parameters in the drop_duplicates() method is “Keep”, the default value of this parameter is “first” which keeps the first occurrence value and deletes the remaining. We can also specify Last and False values to the keep parameter.If keep=False, it will delete all duplicate values. Or if keep= “Last”, it deletes ...
Read MoreWhat does agg() method do in pandas series?
The agg() method in pandas Series is used to apply one or more functions on a series object. By using this agg() method we can apply multiple functions at a time on a series.To use multiple functions at once we need to send those function names as a list of elements to the agg() function.Example# import pandas package import pandas as pd # create a pandas series s = pd.Series([1, 2, 3, 4, 5, 6, 7, 8, 9, 10]) print(s) # Applying agg function result = s.agg([max, min, len]) print('Output of agg method', result)ExplanationThe object “s” has 10 ...
Read MoreHow to add two pandas Series objects by handling None values?
In pandas Series functionalities we have a function called add() which is used to add a series object with another series object. It is also used to add a Series object with an integer value and with a python list.The series.add() method has a fill_values parameter. Which is used to handle the missing values effectively by substituting a float value to this parameter. By default the input to this fill_value parameter is Nan.Exampleimport pandas as pd import numpy as np sr1 = pd.Series(np.arange(1, 6)) print('Series Object 1:', sr1, sep='') sr2 = pd.Series(np.random.randint(10, 20, 4)) print('Series Object 2:', ...
Read MoreWhat does the add() method do in the pandas series?
The basic operation of this add() method in series is used to add a series with another series, or with a list of values, or with a single integer. And it will return a new series with resultant elements.It supports the substitution of fill_values for handling missing data. We can fill Nan Values using the fill_value parameter of the series.add() method.If you want to add a series with a list, then the elements in the list must be equal to the number of elements in the series.Example# import the required packages import pandas as pd import numpy as np ...
Read MoreHow to concrete a single Series into a string Python Pandas library?
Using pandas.Series.to_string() we can convert a single series into a string.Let’s take some examples and see how it’s gonna work.ExampleCreate a pandas Series using string dtype data, then convert it to a string.# create a series ds = pd.Series(["a", "b", "c", "a"], dtype="string") print(ds) # display series s = ds.to_string() # convert to string print() print(repr(s)) display converted outputExplanationThe variable ds holds a pandas Series with all string data by defining dtype as a string. Then convert the series into a string by using the pandas.Series.to_string method, here we define it as ds.to_string(). Finally, the converted string is assigned to ...
Read MoreHow do StringDtype objects differ from object dtype in Python Pandas?
Pandas can not only include text data as an object, it also includes any other data that pandas don’t understand. This means, if you say when a column is an Object dtype, and it doesn’t mean all the values in that column will be a string or text data. In fact, they may be numbers, or a mixture of string, integers, and floats dtype. So with this incompatibility, we can not do any string operations on that column directly.Due to this problem, string dtype is introduced from the pandas 1.0 version, but we need to define it explicitly.See some examples ...
Read MoreWhat are various Text data types in Python pandas?
There are two ways to store textual data in python pandas (for version 1.0.0.to Latest version 1.2.4). On this note, we can say pandas textual data have two data types which are object and StringDtype.In the older version of pandas (1.0), only object dtype is available, in a newer version of pandas it is recommended to use StringDtype to store all textual data. To overcome some disadvantages of using objects dtype, this StringDtype is introduced in the pandas 1.0 version. Still, we can use both object and StringDtype for text data.Let’s take an example, in that create a DataFrame using ...
Read More