Description
Context
All columns are selected by default when a DataFrame
is imported from a file or other sources. The data type for each column is defined based on the default dtype
conversion.
Problem
If the columns are not selected explicitly, it is not easy for developers to know what to expect in the downstream data schema. If the datatype is not set explicitly, it may silently continue the next step even though the input is unexpected, which may cause errors later.
Solution
It is recommended to set their columns and DataType
explicitly.
Type
API-Specific
Existing Stage
Data Cleaning
Effect
Readability
Example
import pandas as pd
df = pd.read_csv('data.csv')
+ df = df[['col1', 'col2', 'col3']]