April 2018
Beginner
238 pages
7h 13m
English
We can use a Python script that calls upon the pandas read_fwf function to read in the data file, break up the columns (according to the field widths provided), and create a DataFrame with the data:
import pandas as pdcolumn_names = ["row","id","year","stint","team","g","ab"]column_widths = [3,9,4,1,3,2,3]df = pd.read_fwf("c:/Users/Dan/baseball.txt", header=None, names=column_names, widths=column_widths)df
This results in a display as follows:
