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

4 votes214 views1 answer
Django is null
Python
0 vote220 views1 answer
Flask admin forgeign keys show literal
Python
5 votes223 views4 answers
OSError: [E050] Can't find model 'en'. It doesn't seem to be a shortcut link, a Python package or a valid path to a data directory.
Python
1 vote235 views1 answer
Counter in django template
Python Django
11 votes223 views6 answers
Python merge dict
Python
0 vote254 views1 answer
Python open all files of type csv
Python
2 votes217 views1 answer
Get text from image python
Python
1 vote226 views1 answer
Valueerror need more than 2 values to unpack findcontours
Python
0 vote245 views1 answer
[Solved] TypeError: 'NoneType' object is not subscriptable
Python
0 vote239 views2 answers
Minecraft python code
Python