Explore the Dataset
Before you start, it's important to take a look at the data you'll work with. There is a list of useful methods which can be applied to the pandas dataframes:
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# info about the dataframe shape, data types
data.info()
# the size of the dataframe
data.shape
# list of the columns
data.columns
# returns all distinct values containing in the column called ColumnName
data['ColumnName'].unique()
# returns the metrics: mean, mode, min, max etc.
data.describe()
# returns top 5 rows
data.head()
# returns top 10 rows (or any other number you'll pass)
data.head(10)
# returns bottom 5 rows
data.tail()
# returns bottom 10 rows (or any other number)
data.tail(10)
# returns 10 random rows
data.sample(10)
123456789101112131415161718192021# info about the dataframe shape, data types data.info() # the size of the dataframe data.shape # list of the columns data.columns # returns all distinct values containing in the column called ColumnName data['ColumnName'].unique() # returns the metrics: mean, mode, min, max etc. data.describe() # returns top 5 rows data.head() # returns top 10 rows (or any other number you'll pass) data.head(10) # returns bottom 5 rows data.tail() # returns bottom 10 rows (or any other number) data.tail(10) # returns 10 random rows data.sample(10)
Tarefa
Swipe to start coding
For given dataset data, extract and print 5 rows using sample() function.
Find all the columns' names and put them to the cols variable.
Find the unique values for each column and output these values.
Solução
9
1
2
3
4
5
6
7
8
9
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/10db3746-c8ff-4c55-9ac3-4affa0b65c16/titanic.csv')
print(data.sample(5))
cols = data.columns
for col in cols:
print(data[col].unique())
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 1. Capítulo 2
9
1
2
3
import pandas as pd
data = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/10db3746-c8ff-4c55-9ac3-4affa0b65c16/titanic.csv')
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
