Repeat Rows in Data Frame n Times [duplicate]

by

Use a combination of pd.DataFrame.loc and pd.Index.repeat

test.loc[test.index.repeat(test.times)]

  id  times
0  a      2
0  a      2
1  b      3
1  b      3
1  b      3
2  c      1
3  d      5
3  d      5
3  d      5
3  d      5
3  d      5

To mimic your exact output, use reset_index

test.loc[test.index.repeat(test.times)].reset_index(drop=True)

   id  times
0   a      2
1   a      2
2   b      3
3   b      3
4   b      3
5   c      1
6   d      5
7   d      5
8   d      5
9   d      5
10  d      5

More Related Contents:

  1. Extract the data and modify an existing excel with openpyxl
  2. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  3. cartesian product in pandas
  4. Keep other columns when doing groupby
  5. What does `ValueError: cannot reindex from a duplicate axis` mean?
  6. How can I filter lines on load in Pandas read_csv function?
  7. Reconstruct a categorical variable from dummies in pandas
  8. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  9. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  10. How to switch columns rows in a pandas dataframe
  11. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  12. Using numpy.genfromtxt to read a csv file with strings containing commas
  13. Plot correlation matrix using pandas
  14. Insert a Pandas Dataframe into mongodb using PyMongo
  15. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  16. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  17. Pandas: How to create a datetime object from Week and Year?
  18. Python Pandas merge samed name columns in a dataframe
  19. How can I replicate rows of a Pandas DataFrame?
  20. TfidfVectorizer in scikit-learn : ValueError: np.nan is an invalid document
  21. In Python pandas, start row index from 1 instead of zero without creating additional column
  22. plotting a histogram on a Log scale with Matplotlib
  23. Changing width of bars in bar chart created using seaborn.factorplot
  24. How to do ‘lateral view explode()’ in pandas [duplicate]
  25. How to use numpy to get the cumulative count by unique values in linear time?
  26. Using regex matched groups in pandas dataframe replace function
  27. converting list of header and row lists into pandas DataFrame
  28. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  29. How to get number of groups in a groupby object in pandas?
  30. Python generating a list of dates between two dates

Leave a Comment