python - Pandas:使用 read_json 读取大 bz2 文件的前 x block 或行

Question

尝试使用 pd.read_json 读取 bz2 文件

 i = 0
while i <3:
  i = i +1 
  df = pd.read_json("file.bz2",lines=True, chunksize = 100)
for c in chunks:
    print(c)

这并不止于 3 个 block 。我如何读取 x 数量的 block 或 x 数量的行。

Answer 1

尝试:

chunks = pd.read_json("file.bz2",lines=True, chunksize = 100)
i = 0
chunk_list = []
for chunk in chunks:
    if i >= 3:
        break
    i += 1
    # do something with that chunk like this:
    result = pd.merge(chunk, merge_df)
    chunk_list.append(result)
 df = pd.concat(chunk_list)