DataFrame Combination¶
All combination rows from list of DataFrame
-
tools.combination.
combination
(dfs)¶ All combination rows from list of DataFrame
Parameters: dfs (list of Pandas DataFrame) – Returns: Return type: Pandas DataFrame Examples
>>> import pandas as pd >>> from tidyframe import combination >>> df_a = pd.DataFrame({'a1': list('ABC'), 'a2': list('CDE')}) >>> df_b = pd.DataFrame({'b1': list('01234'), 'b2': list('56789')}) >>> df_c = pd.DataFrame({'c1': list('pq'), 'c2': list('rs')}) >>> combination([df_a, df_b, df_c]) index_0 a1 a2 index_1 b1 b2 index_2 c1 c2 0 0 A C 0 0 5 0 p r 1 0 A C 0 0 5 1 q s 2 0 A C 1 1 6 0 p r 3 0 A C 1 1 6 1 q s 4 0 A C 2 2 7 0 p r 5 0 A C 2 2 7 1 q s 6 0 A C 3 3 8 0 p r 7 0 A C 3 3 8 1 q s 8 0 A C 4 4 9 0 p r 9 0 A C 4 4 9 1 q s 10 1 B D 0 0 5 0 p r 11 1 B D 0 0 5 1 q s 12 1 B D 1 1 6 0 p r 13 1 B D 1 1 6 1 q s 14 1 B D 2 2 7 0 p r 15 1 B D 2 2 7 1 q s 16 1 B D 3 3 8 0 p r 17 1 B D 3 3 8 1 q s 18 1 B D 4 4 9 0 p r 19 1 B D 4 4 9 1 q s 20 2 C E 0 0 5 0 p r 21 2 C E 0 0 5 1 q s 22 2 C E 1 1 6 0 p r 23 2 C E 1 1 6 1 q s 24 2 C E 2 2 7 0 p r 25 2 C E 2 2 7 1 q s 26 2 C E 3 3 8 0 p r 27 2 C E 3 3 8 1 q s 28 2 C E 4 4 9 0 p r 29 2 C E 4 4 9 1 q s