[Python] Code Example 3 - Filtering Pandas DataFrame




[Source Code]

# Import cars data
import pandas as pd
cars = pd.read_csv('cars.csv', index_col = 0)

# Import numpy, you'll need this
import numpy as np

# Create medium: observations with cars_per_cap between 100 and 500
cpc = cars['cars_per_cap']
between = np.logical_and(cpc > 100, cpc < 500)
medium = cars[between]

# Print medium
print(medium)


[Output]==========================================

     cars_per_cap country  drives_right

RU           200  Russia          True
[Reference]========================================
In [2]: cars
Out[2]: 
     cars_per_cap        country  drives_right
US            809  United States          True
AUS           731      Australia         False
JAP           588          Japan         False
IN             18          India         False
RU            200         Russia          True
MOR            70        Morocco          True

EG             45          Egypt          True

Comments

Post a Comment

Popular posts from this blog

[Python] Code Example 1 - Dictionary

[Source Code] import pandas as pd # Build cars DataFrame names = ['United States', 'Australia', 'Japan', 'India', 'Russia', 'Morocco', 'Egypt'] dr =  [True, False, False, False, True, True, True] cpc = [809, 731, 588, 18, 200, 70, 45] dict = { 'country':names, 'drives_right':dr, 'cars_per_cap':cpc } cars = pd.DataFrame(dict) print(cars) # Definition of row_labels row_labels = ['US', 'AUS', 'JAP', 'IN', 'RU', 'MOR', 'EG'] # Specify row labels of cars cars = pd.DataFrame(dict, row_labels) # Print cars again print(cars) [Output]==========================================        cars_per_cap        country  drives_right     0           809  United States          True     1           731      Australia         False     2          ...
Read more

[Python] Code Example 2 - CSV to DataFrame

[Source Code] # Import pandas as pd import pandas as pd # Fix import by including index_col cars = pd.read_csv('cars.csv', index_col = 0) # Print out cars print(cars) [Output] ==========================================      cars_per_cap        country  drives_right US            809  United States          True AUS           731      Australia         False JAP           588          Japan         False IN             18          India         False RU            200         Russia          True MOR            70    ...
Read more