Concat dataframes

Combine two dataframe in pandas

# Stack the DataFrames on top of each other
vertical_stack = pd.concat([survey_sub, survey_sub_last10], axis=0)

# Place the DataFrames side by side
horizontal_stack = pd.concat([survey_sub, survey_sub_last10], axis=1)

Source: datacarpentry.org

Concat dataframes

result = pd.concat([df1, df2])

Source: pandas.pydata.org

Pandas concat series into dataframe

In [1]: s1 = pd.Series([1, 2], index=['A', 'B'], name='s1')

In [2]: s2 = pd.Series([3, 4], index=['A', 'B'], name='s2')

In [3]: pd.concat([s1, s2], axis=1)
Out[3]:
   s1  s2
A   1   3
B   2   4

In [4]: pd.concat([s1, s2], axis=1).reset_index()
Out[4]:
  index  s1  s2
0     A   1   3
1     B   2   4

Source: stackoverflow.com

Similar codes

18 votes170 views5 answers
Python remove punctuation
Python
-1 vote178 views1 answer
Extracting values in pandas
Python
0 vote181 views1 answer
AttributeError: 'tuple' object has no attribute 'reshape'
Python
0 vote171 views1 answer
Fix certain parameters during curve fit python lambda
Python
0 vote181 views1 answer
Tkinter convert Entry to string
Python
7 votes199 views3 answers
Discord.py level system
Python
0 vote253 views1 answer
Add one to a column pands
Python
0 vote214 views1 answer
Re_path(r'^logout/$',views.logout, {"next_page":'/'},name="logout"), AttributeError: module 'django.contrib.auth.views' has no attribute 'logout'
Python Django
2 votes193 views3 answers
Python pywin32 get current cursor row
Python
11 votes176 views4 answers
Python excel file
Python