Found 507 Articles for Pandas

Python Pandas - Compute indexer and find the previous index value if no exact match

AmitDiwan
Updated on 14-Oct-2021 08:39:02

241 Views

To compute indexer and find the previous index value if no exact match, use the index.get_indexer() method. Also set the method parameter to ffill.At first, import the required libraries −import pandas as pdCreating Pandas index −index = pd.Index([10, 20, 30, 40, 50, 60, 70]) Display the Pandas index −print("Pandas Index...", index)Compute indexer and mask using the "get_indexer". Find the previous index value if no exact match using the "method" parameter. The value is set "ffill" −print("Get the indexes...", index.get_indexer([30, 20, 75, 80, 50, 59], method="ffill")) ExampleFollowing is the code −import pandas as pd # Creating Pandas index index = ... Read More

Python Pandas - Determine if two Index objects with opposite orders are equal or not

AmitDiwan
Updated on 14-Oct-2021 07:27:40

110 Views

To determine if two Index objects with opposite orders are equal or not, use the equals() method.At first, import the required libraries −import pandas as pdCreating Pandas index1 and index2 −index1 = pd.Index([15, 25, 35, 45, 55, 65, 75, 85, 95]) index2 = pd.Index([95, 85, 75, 65, 55, 45, 35, 25, 15])Display the index1 and index2 −print("Pandas Index1...", index1) print("Pandas Index2...", index2)Check whether two index objects with opposite order equal or not −print("Are two Index objects with opposite order equal?" "", index1.equals(index2))ExampleFollowing is the code −import pandas as pd # Creating Pandas index1 and index2 index1 = pd.Index([15, 25, ... Read More

Python Pandas - Determine if two Index objects are equal

AmitDiwan
Updated on 14-Oct-2021 07:25:49

876 Views

To determine if two Index objects are equal, use the equals() method.At first, import the required libraries −import pandas as pdCreating index1 and index2 −index1 = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) index2 = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55])Display the index1 and index2 −print("Pandas Index1...", index1) print("Pandas Index2...", index2)Check whether two index objects are equal −index1.equals(index2) ExampleFollowing is the code −import pandas as pd # Creating index1 and index2 index1 = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) index2 = pd.Index([15, 25, 55, 10, 100, 70, 35, 40, 55]) ... Read More

Python Pandas - Get the second component of the Period

AmitDiwan
Updated on 14-Oct-2021 07:12:34

64 Views

To get the second component of the Period, use the period.second property. At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Ccreating two Period objectsperiod1 = pd.Period("2020-09-23 05:55:30") period2 = pd.Period(freq="S", year = 2021, month = 7, day = 16, hour = 2, minute = 35, second = 10)Display the Period objectsprint("Period1...", period1) print("Period2...", period2)Get the seconds from two Period objectsres1 = period1.second res2 = period2.secondExampleFollowing is the code import pandas as pd # The pandas.Period represents a period of time # creating two Period objects period1 = pd.Period("2020-09-23 05:55:30") period2 = ... Read More

Python Pandas - Get the quarter of the year from Period object

AmitDiwan
Updated on 14-Oct-2021 07:11:14

413 Views

To get the quarter of the year component of the Period, use the period.quarter property. At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Creating two Period objectsperiod1 = pd.Period("2020-02-27 08:32:48") period2 = pd.Period(freq="M", year = 2021, month = 8, day = 16, hour = 2, minute = 35)Display the Period objectsprint("Period1...", period1) print("Period2...", period2)Get the quarter of the year from two Period objectsres1 = period1.quarter res2 = period2.quarterResult is based on the following quarters of an yearQuarter 1 = 1st January to 31st March Quarter 2 = 1st April to 30th June Quarter ... Read More

Python Pandas - Get the month of the year component of the Period

AmitDiwan
Updated on 14-Oct-2021 07:09:49

239 Views

To get the month of the year component of the Period, use the period.month property. At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Creating two Period objectsperiod1 = pd.Period("2020-09-23 05:55:30") period2 = pd.Period(freq="M", year = 2021, month = 8, day = 16, hour = 2, minute = 35)Display the Period objectsprint("Period1...", period1) print("Period2...", period2)Get the month of the year from two Period objectsres1 = period1.month res2 = period2.monthExampleFollowing is the code import pandas as pd # The pandas.Period represents a period of time # creating two Period objects period1 = pd.Period("2020-09-23 ... Read More

Python Pandas - Get the minute of the hour component of the Period

AmitDiwan
Updated on 14-Oct-2021 07:08:37

60 Views

To get the minute of the hour component of the Period, use the period.minute property. At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Creating two Period objectsperiod1 = pd.Period("2020-09-23 05:55:30") period2 = pd.Period(freq="T", year = 2021, month = 7, day = 16, hour = 2, minute = 35)Display the Period objectsprint("Period1...", period1) print("Period2...", period2)Get the minute of the hour from two Period objects res1 = period1.minute res2 = period2.minuteExampleFollowing is the code import pandas as pd # The pandas.Period represents a period of time # creating two Period objects period1 = ... Read More

Python Pandas - Check whether the year is a leap year from the Period object

AmitDiwan
Updated on 14-Oct-2021 07:04:43

179 Views

To check whether the year is a leap year from the Period object, use the period.is_leap_year property. At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Creating two Period objectsperiod1 = pd.Period("2020-09-23 05:55:30") period2 = pd.Period(freq="Y", year = 2021, month = 7, day = 16, hour = 2, minute = 35)Display the Period objectsprint("Period1...", period1) print("Period2...", period2)Check whether the year is a leap yearres1 = period1.is_leap_year res2 = period2.is_leap_yearExampleFollowing is the code import pandas as pd # The pandas.Period represents a period of time # creating two Period objects period1 = pd.Period("2020-09-23 ... Read More

Python Pandas - Get the hour of the day component of the Period

AmitDiwan
Updated on 14-Oct-2021 07:02:54

84 Views

To get the hour of the day component of the Period, use the period.hour property.At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Creating two Period objects −period1 = pd.Period("2020-09-23 05:55:30") period2 = pd.Period(freq="H", year = 2021, month = 7, day = 16, hour = 2, minute = 35)Get the hour of the day from two Period objects −res1 = period1.hour res2 = period2.hourExampleFollowing is the code −import pandas as pd # The pandas.Period represents a period of time # creating two Period objects period1 = pd.Period("2020-09-23 05:55:30") period2 = pd.Period(freq="H", year ... Read More

Python Pandas - Return the string alias of the Time series frequency applied on the given Period object

AmitDiwan
Updated on 14-Oct-2021 07:01:10

77 Views

To return the string alias of the Time series frequency applied on the given Period object, use the period.freqstr property.At first, import the required libraries −import pandas as pdThe pandas.Period represents a period of time. Creating two Period objects −period1 = pd.Period("2020-09-23 03:55:20") period2 = pd.Period(freq="Y", year = 2021, month = 2, day = 14, hour = 2, minute = 35)Display the Period objects −print("Period1...", period1) print("Period2...", period2)Get the string alias of the frequency −res1 = period1.freqstr res2 = period2.freqstrExampleFollowing is the code −import pandas as pd # The pandas.Period represents a period of time # creating two Period ... Read More

Advertisements