Breaking News: Grepper is joining You.com. Read the official announcement!

Split data-frame using Rows

Said KSI answered on May 19, 2022 Popularity 8/10 Helpfulness 5/10

answer Split data-frame using Rows

related split dataframe row on delimiter python

Split data-frame using Rows

Comment

# splitting dataframe by row index
df_1 = df.iloc[:1000,:]
df_2 = df.iloc[1000:,:]
print("Shape of new dataframes - {} , {}".format(df_1.shape, df_2.shape))

Popularity 8/10 Helpfulness 5/10 Language python

Source: www.geeksforgeeks.org

Tags: python rows using

Link to this answer
Share Copy Link

Contributed on Aug 12 2022

Said KSI

0 Answers Avg Quality 2/10

Closely Related Answers

split dataframe row on delimiter python

Comment

In [1]: df = pd.DataFrame({'A': [[0, 1, 2], 'foo', [], [3, 4]],
   ...:                    'B': 1,
   ...:                    'C': [['a', 'b', 'c'], np.nan, [], ['d', 'e']]})

In [2]: df
Out[2]:
           A  B          C
0  [0, 1, 2]  1  [a, b, c]
1        foo  1        NaN
2         []  1         []
3     [3, 4]  1     [d, e]

In [3]: df.explode('A')
Out[3]:
     A  B          C
0    0  1  [a, b, c]
0    1  1  [a, b, c]
0    2  1  [a, b, c]
1  foo  1        NaN
2  NaN  1         []
3    3  1     [d, e]
3    4  1     [d, e]

Popularity 9/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link