Simple question (I guess)

[tchadrack]

I have a txt file with data, sctructured this way:

Output:
[ 
[
    1,
    "ABRAHAN LINFE",
    "JUNIAN",
    10,
    2011,
    "$ 6.277,35"
  ],
[
    1,
    "ABRAHAN LINFE",
    "JUNIAN",
    9,
    2011,
    "$ 6.372,35"
  ],
[
    1,
    "ABRAHAN LINFE",
    "JUNIAN",
    9,
    2011,
    "$ 6.372,35"
  ]
]

The file have millions of records,
How could I load this file into a dataframe in python? What is the best way to do it?

[buran]

This looks like JSON, so pandas.read_json() should work

spam="""[ 
[
    1,
    "ABRAHAN LINFE",
    "JUNIAN",
    10,
    2011,
    "$ 6.277,35"
  ],
[
    1,
    "ABRAHAN LINFE",
    "JUNIAN",
    9,
    2011,
    "$ 6.372,35"
  ],
[
    1,
    "ABRAHAN LINFE",
    "JUNIAN",
    9,
    2011,
    "$ 6.372,35"
  ]
]"""

import pandas as pd

df = pd.read_json(spam)
print(df)

output

Output:
   0              1       2   3     4           5
0  1  ABRAHAN LINFE  JUNIAN  10  2011  $ 6.277,35
1  1  ABRAHAN LINFE  JUNIAN   9  2011  $ 6.372,35
2  1  ABRAHAN LINFE  JUNIAN   9  2011  $ 6.372,35

Of course you can pass a file path or file object instead of string