G+_cody climer Posted March 9, 2014 Share Posted March 9, 2014 I'm currently learning Python, and moving along at a solid pace. I've been given a project by my partner. He has a couple of spreadsheets of data that he'd like to interact with more easily. My practice sheet has a list of routes connecting cities. they're organized by cities on either end of the route, method of transportation (flying, boat, train, etc), and the cost. (this all for a game he's designing. I think python might be okay for working with the data, but it's probably not the prettiest. What do you suggest for working with the data? Link to comment Share on other sites More sharing options...
G+_Dean T Posted March 9, 2014 Share Posted March 9, 2014 Im still fairly new to this myself and only working with c sharp / .net but I made a basic phone book app that stored the data usings .nets ability to implement a local sql server for holding the data which worked really well. Link to comment Share on other sites More sharing options...
G+_cody climer Posted March 10, 2014 Author Share Posted March 10, 2014 ah cool. I tracked down some ways to do C#, and maybe .net too on linux. thanks for the suggestion :) Link to comment Share on other sites More sharing options...
G+_S. LeBeau Kpadenou Posted March 14, 2014 Share Posted March 14, 2014 If you can pull the data out of the spreadsheet into a file with rows separated by commas or newlines, you might actually want to look at Bash. Bash is the command prompt for Unix/Linux/BSD/Mac. The commands can be collected into a file called a script. It supports variables, if statements and much more. It is available on most platforms. Bash excels at text manipulation and parsing. I once needed to go through voter rolls sent by the state, and pull out voters from a particular county. The rolls came in a text file, one voter per line. I wrote a quickish Python script to do the work. After I was done, I realized I could have done the same from the command line or from a script in 1-2 lines. Link to comment Share on other sites More sharing options...
G+_Lee Crocker Posted March 15, 2014 Share Posted March 15, 2014 Python is marvelous for data manipulation. Much easier than C#, more powerful and flexible than a shell. Stick with it, it's a good choice. Your first task should be to either export the data in some textual format, or else find a Python module that can read the existing format. Then figure out which Python data structure best supports the operations you need. Link to comment Share on other sites More sharing options...
Recommended Posts