To extract year from the DateTimeIndex with specific time series frequency, use the DateTimeIndex.day property.At first, import the required libraries −import pandas as pdDatetimeIndex with period 6 and frequency as D i.e. day. The timezone is Australia/Sydney −datetimeindex = pd.date_range('2021-10-20 02:35:55', periods=6, tz='Australia/Sydney', freq='D')Display DateTimeIndex −print("DateTimeIndex...", datetimeindex)Get the day −print("Getting the day..", datetimeindex.day) ExampleFollowing is the code −import pandas as pd # DatetimeIndex with period 6 and frequency as D i.e. day # timezone is Australia/Sydney datetimeindex = pd.date_range('2021-10-20 02:35:55', periods=6, tz='Australia/Sydney', freq='D') # display DateTimeIndex print("DateTimeIndex...", datetimeindex) # display DateTimeIndex frequency print("DateTimeIndex frequency...", datetimeindex.freq) # ... Read More

To extract month number from the DateTimeIndex with specific time series frequency, use the DateTimeIndex.month property.At first, import the required libraries −import pandas as pdDatetimeIndex with period 6 and frequency as M i.e. month. The timezone is Australia/Sydney −datetimeindex = pd.date_range('2021-09-24 02:35:55', periods=6, tz='Australia/Sydney', freq='M')Display DateTimeIndex −print("DateTimeIndex...", datetimeindex)Get the month number i.e. January=1, february=2, ..., December=12 −print("Getting the month number..", datetimeindex.month) ExampleFollowing is the code −import pandas as pd # DatetimeIndex with period 6 and frequency as M i.e. month # timezone is Australia/Sydney datetimeindex = pd.date_range('2021-09-24 02:35:55', periods=6, tz='Australia/Sydney', freq='M') # display DateTimeIndex print("DateTimeIndex...", datetimeindex) # ... Read More

To extract year from the DateTimeIndex with specific time series frequency, use the DateTimeIndex.year property.At first, import the required libraries −import pandas as pdDatetimeIndex with period 6 and frequency as Y i.e. years. The timezone is Australia/Sydney −datetimeindex = pd.date_range('2021-09-24 02:35:55', periods=6, tz='Australia/Sydney', freq='Y')Display DateTimeIndex −print("DateTimeIndex...", datetimeindex)Get the year −print("Getting the year name..", datetimeindex.year) ExampleFollowing is the code −import pandas as pd # DatetimeIndex with period 6 and frequency as Y i.e. years # timezone is Australia/Sydney datetimeindex = pd.date_range('2021-09-24 02:35:55', periods=6, tz='Australia/Sydney', freq='Y') # display DateTimeIndex print("DateTimeIndex...", datetimeindex) # display DateTimeIndex frequency print("DateTimeIndex frequency...", datetimeindex.freq) ... Read More

To create a datetime, we will use the date_range(). The periods and the time zone will also be set with the frequency. At first, import the required libraries −import pandas as pdDatetimeIndex with period 8 and frequency as M i.e. months. The timezone is Australia/Sydney −datetime = pd.date_range('2021-09-24 02:35:55', periods=8, tz='Australia/Sydney', freq='M') Display the datetime −print("DateTime...", datetime)ExampleFollowing is the code −import pandas as pd # DatetimeIndex with period 8 and frequency as M i.e. months # timezone is Australia/Sydney datetime = pd.date_range('2021-09-24 02:35:55', periods=8, tz='Australia/Sydney', freq='M') # display print("DateTime...", datetime) # get the day name print("Getting the ... Read More

To return vector of label values using level name in the MultiIndex, use the MultiIndex.get_level_values() method in Pandas.At first, import the required libraries −import pandas as pdMultiIndex is a multi-level, or hierarchical, index object for pandas objects −multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two'])Display the MultiIndex −print("The MultiIndex...", multiIndex) Get level values using level name "Two" −print("Level values using level name...", multiIndex.get_level_values("Two"))ExampleFollowing is the code −import pandas as pd # MultiIndex is a multi-level, or hierarchical, index object for pandas objects multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two']) # display the MultiIndex print("The MultiIndex...", multiIndex) # get the levels ... Read More

To return vector of label values using integer position of the level in the MultiIndex, use the MultiIndex.get_level_values() method in Pandas. Set the level as an argument.At first, import the required libraries −import pandas as pdMultiIndex is a multi-level, or hierarchical, index object for pandas objects −multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two']) Display the MultiIndex −print("The MultiIndex...", multiIndex)Get level values at level 0 −print("Level values at level 0...", multiIndex.get_level_values(0)) ExampleFollowing is the code −import pandas as pd # MultiIndex is a multi-level, or hierarchical, index object for pandas objects multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two']) # display ... Read More

To return vector of label values for requested level in a MultiIndex, use the multiIndex.get_level_values() method. Set the level name as an argument.At first, import the required libraries −import pandas as pdMultiIndex is a multi-level, or hierarchical, index object for pandas objects −multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two'])Display the MultiIndex −print("The MultiIndex...", multiIndex) Get the levels in MultiIndex −print("The levels in MultiIndex...", multiIndex.levels)Get level values at level 0 −print("Level values...", multiIndex.get_level_values(0)) ExampleFollowing is the code −import pandas as pd # MultiIndex is a multi-level, or hierarchical, index object for pandas objects multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two']) # ... Read More

To get location and sliced index for requested label/ level in a MultiIndex, use the get_loc_level() method in Pandas. Use the drop_level parameter and set it False to avoid dropping the level.At first, import the required libraries −import pandas as pdMultiIndex is a multi-level, or hierarchical, index object for pandas objects −multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two'])Display the MultiIndex −print("The MultiIndex...", multiIndex) Get the location and sliced index. To avoid dropping a level, we have used the "drop_level" parameter with value "False" −print("Get the location and sliced index (avoid dropping the level)...", multiIndex.get_loc_level('r', drop_level=False))ExampleFollowing is the code −import pandas as ... Read More

To get location and sliced index for requested label/ level in a MultiIndex, use the get_loc_level() method in Pandas.At first, import the required libraries −import pandas as pdMultiIndex is a multi-level, or hierarchical, index object for pandas objects −multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two'])Display the MultiIndex −print("The MultiIndex...", multiIndex) Get the location and sliced index −print("Get the location and sliced index...", multiIndex.get_loc_level('r'))ExampleFollowing is the code −import pandas as pd # MultiIndex is a multi-level, or hierarchical, index object for pandas objects multiIndex = pd.MultiIndex.from_arrays([list('pqrrss'), list('strvwx')], names=['One', 'Two']) # display the MultiIndex print("The MultiIndex...", multiIndex) # get the ... Read More

To get location for a sequence of labels in a MultiIndex, use the MutiIndex.get_locs() method in Pandas.At first, import the required libraries −import pandas as pdMultiIndex is a multi-level, or hierarchical, index object for pandas objects −multiIndex = pd.MultiIndex.from_arrays([list('pqrrst'), list('kytssp')]) Display the MultiIndex −print("The MultiIndex...", multiIndex)Get the location for a sequence of labels −print("Get the locations in MultiIndex...", multiIndex.get_locs('s')) ExampleFollowing is the code −import pandas as pd # MultiIndex is a multi-level, or hierarchical, index object for pandas objects multiIndex = pd.MultiIndex.from_arrays([list('pqrrst'), list('kytssp')]) # display the MultiIndex print("The MultiIndex...", multiIndex) # get the levels in MultiIndex print("The ... Read More