How can I automate the sequence of dataframe?

user_18352361 0
Viewed 51

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.

pandas dataframe python
1 Answers

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)
user_63615310
Related