6 examples of 'merge multiple dataframes pandas' in Python

813
def merge(old_cols, new_cols):
814
    return old_cols + new_cols

57
def merge(left, right):
58
    return left.merge(right, on=on, how=how, suffixes=(lsuffix, rsuffix))

332
def merge_datasets(self, other):
333
    """
334
    This operation combines two dataframes into one new DataFrame.
335
    If the operation is combining two SpatialDataFrames, the
336
    geometry_type must match.
337
    """
338
    if isinstance(other, SpatialDataFrame) and \
339
        other.geometry_type == self.geometry_type:
340
        return pd.concat(objs=[self, other], axis=0)
341
    elif isinstance(other, DataFrame):
342
        return pd.concat(objs=[self, other], axis=0)
343
    elif isinstance(other, Series):
344
        self['merged_datasets'] = other
345
    elif isinstance(other, SpatialDataFrame) and \
346
         other.geometry_type != self.geometry_type:
347
        raise ValueError("Spatial DataFrames must have the same geometry type.")
348
    else:
349
        raise ValueError("Merge datasets cannot merge types %s" % type(other))

24
def _merge_dataframes(self, dataset_readers_list):
25
26
    final_df = None
27
    all_dfs = []
28
    keys = []
29
30
    for dataset, readers in dataset_readers_list:
31
        dataset_df = readers[0]
32
        for df in readers[1:]:
33
            if df is None:
34
                continue
35
            dataset_df = dataset_df.add(df, fill_value=0.)
36
37
        all_dfs.append(dataset_df)
38
        keys.append(dataset)
39
40
    final_df = pd.concat(all_dfs, keys=keys, names=['dataset'], sort=True)
41
42
    return final_df.reset_index()

29
def _concat(df, type):
30
    if df is None:
31
        df = pd.DataFrame(_object_blocks[type])
32
    else:
33
        _df = pd.DataFrame(_object_blocks[type])
34
        df = pd.concat([df, _df], sort=True)
35
    return df

6
def default_merger(x, y):
7
	import pandas as pd
8
	return pd.concat([x, y])