Created
September 20, 2020 18:24
-
-
Save tiagofer/0e21d6e34f4949e20a01946f924c4ec1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def fetch_github(): | |
#criando as urls para 7 rodadas | |
urls = [] | |
for i in range(7): | |
urls.append(f'https://raw.githubusercontent.com/henriquepgomide/caRtola/master/data/2020/rodada-{i+1}.csv') | |
#criando lista de dataframes das rodadas | |
rodadas = [] | |
for url in urls: | |
rodadas.append(pd.read_csv(url)) | |
#remover coluna Unnamed: 0 | |
for rodada in rodadas: | |
rodada.drop('Unnamed: 0',axis=1,inplace=True) | |
#adicionando coluna DP até a rodada 3 | |
for i in range(3): | |
rodadas[i]['DP'] = 0 | |
#criando dataframe com todas as rodadas | |
df_rodadas = pd.DataFrame() | |
try: | |
for rodada in rodadas: | |
df_rodadas = df_rodadas.append(rodada) | |
except Exception as error: | |
return error | |
return df_rodadas |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment