from list of lists to dataframe
import pandas as pd data = [['New York Yankees', 'Acevedo Juan', 900000, 'Pitcher'], ['New York Yankees', 'Anderson Jason', 300000, 'Pitcher'], ['New York Yankees', 'Clemens Roger', 10100000, 'Pitcher'], ['New York Yankees', 'Contreras Jose', 5500000, 'Pitcher']] df = pd.DataFrame.from_records(data)