Sqlite output differs when called in Python from when called in sqlite3

I have a table in an sqlite db and I receive two outputs when run in sqlite3 through my terminal and when called upon in a python script. The output in the python script is odd, it isn't an actual datapoint.

The table looks like:

    SELECT manager_name, points_for, wins, year FROM standings;

    manager_name    points_for  wins        year
     Eddy           1513.82     8           2014 
     Drew           1351.8      10          2014
     Sammy          1497.72     10          2014 
     Mike2          1474.22     10          2014 
     Sam            1360.94     7           2014 
     Rick           1379.1      7           2014          
     Jeff           1381.1      6           2014          
     Josh           1411.16     5           2014         
     Bay            1237.2      5           2014         
     Mike           1187.68     6           2014          
     G              1208.66     5           2014                   
     Brett          1245.78     5           2014          
     Luke           1395.76     4           2014              
     A  Roberman    1331.1      3           2014 

When I run the following query in sqlite3 I receive the correct response (most wins with points as tiebreaker)

    SELECT max(wins), points_for, manager_name FROM (SELECT manager_name, wins, points_for FROM standings ORDER BY wins DESC, points_for DESC);

OUTPUT:

manager_name   points_for   max(wins)    year
  SamK          1497.72       10         2014

But when I run the query through a python script I get a very odd result.

    df = pd.read_sql(" SELECT max(wins), points_for, manager_name, year FROM (SELECT manager_name, wins, points_for, year FROM standings ORDER BY wins DESC, points_for DESC)", conn)

print df OUTPUT:

               max(wins)  points_for manager_name  year
        0         10      1497.72        Al R      2014

Bear in mind I have run many similar python scripts in this db and have never gotten an output that did not make sense like this.