concat_with_column_name¶
In [1]:
import pandas as pd
s1 = pd.Series(range(5), name="a")
s2 = pd.Series(range(1, 6), name="b")
s3 = pd.Series(range(2, 7))
s4 = pd.Series(range(3, 8))
pd.concat([
    pd.concat(
        [
            pd.DataFrame(s1),
            s2.to_frame()
        ], axis=1
    ),
    pd.concat([s3, s4], keys=list("cd"), axis=1),
    pd.DataFrame({"e": s3, "f": s4})
], axis=1).head()
Out[1]:
| a | b | c | d | e | f | |
|---|---|---|---|---|---|---|
| 0 | 0 | 1 | 2 | 3 | 2 | 3 | 
| 1 | 1 | 2 | 3 | 4 | 3 | 4 | 
| 2 | 2 | 3 | 4 | 5 | 4 | 5 | 
| 3 | 3 | 4 | 5 | 6 | 5 | 6 | 
| 4 | 4 | 5 | 6 | 7 | 6 | 7 |