Export to CSV

[jmartin1344]

I'd like to export all data from a given nfldb query into a CSV file so i can load in Tableau Public - I remember this was possible in nflgame I think.

Could anyone provide an example of how to do this? I'm fairly basic at this stuff.

Appreciate it.

[MargareeMan]

For starters see 'https://github.com/derek-adair/nflgame/wiki/Tutorial-for-non-programmers:-Installation-and-examples' , the section: "I don't care about Python. Can I use Excel please?". Also, look at the original nfldb Wiki 'https://github.com/BurntSushi/nfldb/wiki' . Your question, I think is really a Python or SQL question. The examples should get you started.

I dug up a piece of code I wrote a couple of years ago (and for this example changed the year in the query). I am not a programmer and I do not use Python (except by example). I don't even remember where I got this code from (so I apologize to anyone I am copying from without reference).

import nflgame
import nflgame.sched
import csv

schedule_games = nflgame.sched.games

with open("E:\NFLDB 2018 incarnate\\2018 Schedule.csv", 'wb') as csvfile:
    schedulewriter = csv.writer(csvfile, delimiter=',')
    schedulewriter.writerow(['Key','Home', 'Away', 'Week', 'Year'])
    for key in schedule_games:
        game = schedule_games[key]
        if game['year'] == 2018 and game['season_type'] == 'REG':
            schedulewriter.writerow([game['eid'], game['home'], game['away'], game['week'], game['year']])