# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

import pandas as pd

# +
df_prof_Part2_step1 = pd.read_csv('player_info_Step2_part1.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_prof_Part2_step2 = pd.read_csv('player_info_Step2_part2.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_prof_Part2_step3 = pd.read_csv('player_info_Step2_part3.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_prof_Part1 = pd.read_csv('player_info_100k.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')


# -

df_all_prof = pd.concat([df_prof_Part1,df_prof_Part2_step3,df_prof_Part2_step2,df_prof_Part2_step1],sort=False)

df_all_prof.head()

df_all_prof.info()

df_all_prof['steamid'].nunique()

df_all_prof.to_csv('player_info_200k.csv')





# +
df_friend_Part2_step1 = pd.read_csv('player_friend_info_Step2_part1.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_friend_Part2_step2 = pd.read_csv('player_friend_info_Step2_part2.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_friend_Part2_step3 = pd.read_csv('player_friend_info_Step2_part3.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_friend_Part1 = pd.read_csv('player_friend_info_100k.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')



# +
df_all_friend = pd.concat([df_friend_Part1,df_friend_Part2_step3,df_friend_Part2_step2,df_friend_Part2_step1],sort=False)


# -

df_all_friend.head()

df_all_friend.info()

df_all_friend['steamid'].nunique()

df_all_friend['steamid_orig'].nunique()

df_all_friend.to_csv('player_friend_info_200k.csv')







# +
df_game_Part2_step1 = pd.read_csv('player_game_info_Step2_part1.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_game_Part2_step2 = pd.read_csv('player_game_info_Step2_part2.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_game_Part2_step3 = pd.read_csv('player_game_info_Step2_part3.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')
df_game_Part1 = pd.read_csv('player_game_info_100k.csv',dtype={'steamid': str}).drop('Unnamed: 0',axis='columns')



# +
df_all_game = pd.concat([df_game_Part1,df_game_Part2_step3,df_game_Part2_step2,df_game_Part2_step1],sort=False)


# -

df_all_game.head()

df_all_game.info()

df_all_game['steamid'].nunique()



df_all_game.to_csv('player_game_info_200k.csv')



StarcoderdataJupyterScriptsDedupFiltered