~?~

~?~

~?~

mrjob v0.4.2 documentation ← Why mrjob? Concepts → Home Guides ¶ ¶ Install with pip : pip install mrjob or from a git clone of the source code : python setup.py test && python setup.py install ¶ Open a file called word_count.py and type this into it: from mrjob.job import MRJob class MRWordFrequencyCount ( MRJob ): def mapper ( self , _ , line ): yield "chars" , len ( line ) yield "words" , len ( line . split ()) yield "lines" , 1 def reducer ( self , key , values ): yield key , sum ( values ) if __name__ == '__main__' : MRWordFrequencyCount . run () Now go back to the command line, find your favorite body of text (such mrjob’s README.rst , or even your new file word_count.py ), and try this: $ python word_count.py my_file.txt You should see something like this: "chars" 3654 "lines" 123 "words" 417 Congratulations!...

~?~

Execute SQL on CSV files querycsv.py querycsv.py is a Python module and program that allows you to execute SQL code against data contained in one or more comma-separated-value (CSV) files. The output of the SQL query will be displayed on the console by default, but may be saved in a new CSV file. Actions that can be performed with the querycsv program include: Execute a single SQL statement, specified on the command line, against the specified data. Execute multiple SQL statements, read from a script file, against the specified data. Read data either from one or more CSV files or from a Sqlite data file. Create a new CSV file containing selected, summarized, data. Create a Sqlite data file from one or more CSV files. The Sqlite file can then be used either by querycsv or by other programs, such as the Python Sqliteplus shell . querycsv.py -i <fname> [other options] [S...