How can I automate the sequence of dataframe?-CodePudding

My dataframe:

     *Ca *O *Ca  Ca  Hy
0    1   2   3   4   5
1    1             
2    1    5            
3    1    6  7   8            
4    5                
5    6         
6    6                
7    6                
8    9              
9    9  12          
10   9  9   10   11

Desired dataframe will look like:

     *Ca *O *Ca  Ca  Hy
0    1   2   3   4   5
1    1             
2    1    5            
3    1    6  7   8            
4    5                
5    6         
6    6                
7    6                
8    9              
9    9   12          
10   9    9   10   11
11   10   12  13  14   15
12   10   15
13   10   16  17   18  
14   10
15   15
16   16
17   16
18   16
.........

That equivalent to: Ca[i] = a and Ca[i 10] = a 10 but Ca[i 9] =! a 9 We can say that i => 10 I want to get the sequence every 10 rows in a range of 250. Hopefully, it is clear.

CodePudding user response：

IIUC,

pd.concat([df, df 10], ignore_index=True)

Or perhaps:

pd.concat([df i for i in range(0, 250, 10)], ignore_index=True).head(40)

Well looky there, @piRSquared sighting.....

pd.concat(map(df.add, range(0, 250, 10)), ignore_index=True)