How to Capture Data with Pandas?

Question

I work with a database that uses frequency, and I want to analyze the frequency data and transform it into several lines. Follow image example:

I want to make line 6, for example, become 6 equal lines with the same data. I thought to "rewrite" the whole spreadsheet and save as a new one because it may be that only modify the lines give some problem.

Answer 1

I believe that what you seek can be achieved with reindex and repeat:

df.reindex(df.index.repeat(df.FREQUENCIA))

Unfortunately I have no way to demonstrate the output of the data because you uploaded an image as sample and I have no way to "copy" the data in this way