Merchant Name is an integer

[xhluca]

In the screen shot in the readme, the merchant name is a string, but when I load the CSV file using pandas, I get an integer value instead:

          User  Card  Year  Month  Day   Time   Amount           Use Chip        Merchant Name  Merchant City Merchant State      Zip   MCC Errors? Is Fraud?
0            0     0  2002      9    1  06:21  $134.09  Swipe Transaction  3527213246127876953       La Verne             CA  91750.0  5300    None        No
1            0     0  2002      9    1  06:42   $38.48  Swipe Transaction  -727612092139916043  Monterey Park             CA  91754.0  5411    None        No
2            0     0  2002      9    2  06:22  $120.34  Swipe Transaction  -727612092139916043  Monterey Park             CA  91754.0  5411    None        No
3            0     0  2002      9    2  17:45  $128.95  Swipe Transaction  3414527459579106770  Monterey Park             CA  91754.0  5651    None        No
4            0     0  2002      9    3  06:23  $104.71  Swipe Transaction  5817218446178736267       La Verne             CA  91750.0  5912    None        No
...        ...   ...   ...    ...  ...    ...      ...                ...                  ...            ...            ...      ...   ...     ...       ...
24386895  1999     1  2020      2   27  22:23  $-54.00   Chip Transaction -5162038175624867091      Merrimack             NH   3054.0  5541    None        No
24386896  1999     1  2020      2   27  22:24   $54.00   Chip Transaction -5162038175624867091      Merrimack             NH   3054.0  5541    None        No
24386897  1999     1  2020      2   28  07:43   $59.15   Chip Transaction  2500998799892805156      Merrimack             NH   3054.0  4121    None        No
24386898  1999     1  2020      2   28  20:10   $43.12   Chip Transaction  2500998799892805156      Merrimack             NH   3054.0  4121    None        No
24386899  1999     1  2020      2   28  23:10   $45.13   Chip Transaction  4751695835751691036      Merrimack             NH   3054.0  5814    None        No

[JBI1971]

Hi, did you get any resolution on this? Same issue for me.

[itacdonev]

Any solution for this issue? I am having the same problem? Thanks.

[tehbone]

For those still interested, based on the supplied code the exact text of the Merchant Name does not matter. The Merchant Name column gets encoded into an integer value based on the vocabulary of that column. For example, if the original Merchant Name was "8-Ball's Pool Shack", replacing that text with an arbitrary value "34" has no effect as long as each occurrence of that name is given the same value.