On Jan 4, 4:55 pm, [EMAIL PROTECTED] wrote: > Petr thanks so much for your input. I'll try to learnSQL, especially > if I'll do a lot of database work. > > I tried to do it John's way as en exercise and I'm happy to say I > understand a lot more. Basically I didn't realize I could nest > dictionaries like db = {country:{genre:{sub_genre:3}}} and call them > like db[country][genre][sub_genre]. The Python Cookbook was quite > helpful to figure out why items needed to be added the way they did. > Also using the structure of the dictionary was a conceptually easier > solution than what I found > onhttp://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/334695. > > So, now I need to work on writing it to Excel. I'll update with the > final code. >
Hi, good to know you have succeded. I think it is matter of taste which way to go (dictionary or database). My feelig is: for data use database! If you are trying to work with data, you will need it sooner or later anyway. Again: database is made for data! :-) Writing your data to excel? Just save your numbers separated by commas in the file with the extension csv (my_data.csv) and you can open it directly in Excel. Good luck :-) Petr -- http://mail.python.org/mailman/listinfo/python-list