I have some user data downloaded using the Steam API (I am following the approach described here) and I need to find the format for each entry of the CSV file I generated (available here).

Using Python, the solution I came up with is the following:

import pandas as pd
import sys

df1 = pd.read_csv("./data/csgo_cheater_data_01_14_21_full.csv")
for ii in range(189):
    print(df1.columns[ii], type(df1[df1.columns[ii]].values[0]))

Running this snipped, the result is that most variables are float64, plus a few int64. Does it make sense? Is this the real format of the data or are they somehow converted when retrieved using the API?

  • 1
    \$\begingroup\$ Since you can open csv in any text editor and the first line give you somelike total_of_x, numeric values do make sense \$\endgroup\$ – Zibelas Jan 21 at 12:27
  • 2
    \$\begingroup\$ Have you found any specific variables that don't look like they make sense in the format your code reads them currently? A concrete example can help focus answers. Or, if all the variables make sense to you in their current format, then what is the problem to solve? \$\endgroup\$ – DMGregory Jan 21 at 12:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.