DataFrame.period_range()

Pandas date & time Pandas

Generate Periodindex of fixed frequency.

Options
start Start of the generating period.
end End of the generating period.
periods number of periods to generate.

freq Frequency is 'D' by default. We can specify to others.

Examples

import pandas as pd 
pd.period_range(start='4/1/2020', end='12/31/2020',freq='M')
Output , Here frequency is Months
PeriodIndex(['2020-04', '2020-05', '2020-06', '2020-07', '2020-08', '2020-09',
             '2020-10', '2020-11', '2020-12'],
            dtype='period[M]', freq='M')

Q : Quarter end frequency

pd.period_range(start='4/1/2020', end='12/31/2020',freq='Q')
Output
PeriodIndex(['2020Q2', '2020Q3', '2020Q4'], dtype='period[Q-DEC]', freq='Q-DEC')

Weekly frequency

pd.period_range(start='4/1/2020', end='4/30/2020',freq='W')
Output
PeriodIndex(['2020-03-30/2020-04-05', '2020-04-06/2020-04-12',
             '2020-04-13/2020-04-19', '2020-04-20/2020-04-26',
             '2020-04-27/2020-05-03'],
            dtype='period[W-SUN]', freq='W-SUN')
We used start and end options in above code. Similarly we can use other options.

Business Day

pd.period_range(start='4/1/2020', end='4/30/2020',freq='B')
Output
PeriodIndex(['2020-04-01', '2020-04-02', '2020-04-03', '2020-04-06',
             '2020-04-07', '2020-04-08', '2020-04-09', '2020-04-10',
             '2020-04-13', '2020-04-14', '2020-04-15', '2020-04-16',
             '2020-04-17', '2020-04-20', '2020-04-21', '2020-04-22',
             '2020-04-23', '2020-04-24', '2020-04-27', '2020-04-28',
             '2020-04-29', '2020-04-30'],
            dtype='period[B]', freq='B')

periods

We can specify integer values like periods=3, this is optional.
import pandas as pd 
pd.period_range(start='4/20/2020',periods=3,freq='M')
Output
PeriodIndex(['2020-04', '2020-05', '2020-06'], dtype='period[M]', freq='M')

name

We can give name of to the resulting DataFrame.

Pandas date & time to_datetime() date_range() strftime()
Subscribe to our YouTube Channel here

Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com



    Post your comments , suggestion , error , requirements etc here





    Python Video Tutorials
    Python SQLite Video Tutorials
    Python MySQL Video Tutorials
    Python Tkinter Video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2022 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer