Bem-vindo(a) ao curso!

Introdução à importação de dados em Python

Hugo Bowne-Anderson

Data Scientist at DataCamp

Importar dados

Arquivos texto (flat files), ex.: .txt, .csv
Arquivos de outros softwares

ch_1_1_v2.004.png

Importar dados

Arquivos texto (flat files), ex.: .txt, .csv
Arquivos de outros softwares
Bancos de dados relacionais

ch_1_1_v2.005.png

Arquivos de texto simples

Dados tabulares

titanic.csv

                        Name      Sex  Cabin  Survived
     Braund, Mr. Owen Harris     male    NaN         0
  Cumings, Mrs. John Bradley   female    C85         1
      Heikkinen, Miss. Laina   female    NaN         1
Futrelle, Mrs. Jacques Heath   female   C123         1
    Allen, Mr. William Henry     male    NaN         0

¹ Fonte: Kaggle

Dados tabulares

titanic.csv

titanic.csv com uma linha destacada

Dados tabulares

titanic.csv

titanic.csv com uma coluna destacada

Arquivo texto (flat file)

Lendo um arquivo de texto

filename = 'huck_finn.txt'

file = open(filename, mode='r')  # 'r' is to read

text = file.read()

file.close()

Imprimindo um arquivo de texto

print(text)

YOU don't know about me without you have read a book by
the name of The Adventures of Tom Sawyer; but that 
ain't no matter. That book was made by Mr. Mark Twain,
and he told the truth, mainly. There was things which 
he stretched, but mainly he told the truth.  That is 
nothing. never seen anybody but lied one time or 
another, without it was Aunt Polly, or the widow, or 
maybe Mary. Aunt Polly--Tom's Aunt Polly, she is--and
Mary, and the Widow Douglas is all told about in that
book, which is mostly a true book, with some 
stretchers, as I said before.

Escrevendo em um arquivo

filename = 'huck_finn.txt'
file = open(filename, mode='w')  # 'w' is to write
file.close()

Gerenciador de contexto with

with open('huck_finn.txt', 'r') as file:
    print(file.read())

YOU don't know about me without you have read a book by
the name of The Adventures of Tom Sawyer; but that 
ain't no matter. That book was made by Mr. Mark Twain,
and he told the truth, mainly. There was things which 
he stretched, but mainly he told the truth.  That is 
nothing. never seen anybody but lied one time or 
another, without it was Aunt Polly, or the widow, or 
maybe Mary. Aunt Polly--Tom's Aunt Polly, she is--and 
Mary, and the Widow Douglas is all told about in that 
book, which is mostly a true book, with some 
stretchers, as I said before.

Nos exercícios, você vai:

Imprimir arquivos no console
Imprimir linhas específicas
Falar sobre flat files

Vamos praticar!

Introdução à importação de dados em Python