# pandas.DataFrame.join¶

DataFrame.join(other, on=None, how='left', lsuffix='', rsuffix='', sort=False)

Join columns with other DataFrame either on index or on a key column. Efficiently Join multiple DataFrame objects by index at once by passing a list.

Parameters: other : DataFrame, Series with name field set, or list of DataFrame Index should be similar to one of the columns in this one. If a Series is passed, its name attribute must be set, and that will be used as the column name in the resulting joined DataFrame on : column name, tuple/list of column names, or array-like Column(s) to use for joining, otherwise join on index. If multiples columns given, the passed DataFrame must have a MultiIndex. Can pass an array as the join key if not already contained in the calling DataFrame. Like an Excel VLOOKUP operation how : {‘left’, ‘right’, ‘outer’, ‘inner’} How to handle indexes of the two objects. Default: ‘left’ for joining on index, None otherwise left: use calling frame’s index right: use input frame’s index outer: form union of indexes inner: use intersection of indexes lsuffix : string Suffix to use from left frame’s overlapping columns rsuffix : string Suffix to use from right frame’s overlapping columns sort : boolean, default False Order result DataFrame lexicographically by the join key. If False, preserves the index order of the calling (left) DataFrame joined : DataFrame

Notes

on, lsuffix, and rsuffix options are not supported when passing a list of DataFrame objects
{"ft_lang_label":"__label__en","ft_lang_prob":0.70530593,"math_prob":0.66923153,"size":1521,"snap":"2022-40-2023-06","text_gpt3_token_len":345,"char_repetition_ratio":0.15095584,"word_repetition_ratio":0.016460905,"special_character_ratio":0.21827745,"punctuation_ratio":0.15488215,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.96353287,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2023-02-01T02:14:54Z\",\"WARC-Record-ID\":\"<urn:uuid:046346ca-382d-412e-9a77-c3214b4847bf>\",\"Content-Length\":\"15154\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:fd24f6f2-1596-45f6-9a5e-fee7bb53acee>\",\"WARC-Concurrent-To\":\"<urn:uuid:51e64474-b6ea-492c-9188-34c91e7f84f6>\",\"WARC-IP-Address\":\"172.67.71.236\",\"WARC-Target-URI\":\"https://pandas.pydata.org/pandas-docs/version/0.18.1/generated/pandas.DataFrame.join.html\",\"WARC-Payload-Digest\":\"sha1:EGWTCZRXHZKRLOOUZCSM4PALPGVKSIM2\",\"WARC-Block-Digest\":\"sha1:OQ47USEKJ3DNPVYRBV56VMUSNJV7NBCR\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2023/CC-MAIN-2023-06/CC-MAIN-2023-06_segments_1674764499899.9_warc_CC-MAIN-20230201013650-20230201043650-00782.warc.gz\"}"}