Pandas go through csv file

data = pd.read_csv(
    "data/files/complex_data_example.tsv",      # relative python path to subdirectory
    sep='\t'           # Tab-separated value file.
    quotechar="'",        # single quote allowed as quote character
    dtype={"salary": int},             # Parse the salary column as an integer 
    usecols=['name', 'birth_date', 'salary'].   # Only load the three columns specified.
    parse_dates=['birth_date'],     # Intepret the birth_date column as a date
    skiprows=10,         # Skip the first 10 rows of the file
    na_values=['.', '??']       # Take any '.' or '??' values as NA
)

Source: shanelynn.ie

Similar codes

0 vote90 views1 answer
Kubernetes field selector
Go
0 vote162 views2 answers
Display logo in material ui
Go
6 votes135 views1 answer
Never back down
Go
2 votes172 views1 answer
How to get screen width and height in godot
Go
22 votes181 views1 answer
Drop mongo database
Go
7 votes134 views2 answers
What is go
Go
3 votes141 views3 answers
Golang time now
Go
1 vote134 views1 answer
Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12.4:test (default-test) on project mockito-course: There are test failures.
Go
0 vote147 views1 answer
Change color google translate select language
Go
4 votes127 views1 answer
Ubuntu mongodb db list
Go