Liquid 9

Liquid 9 is looking for a senior developer who will become a critical member of our interactive team.

The developer position consists of two main responsibilities:

• Build websites for clients using Django if possible?
• Maintain client sites and our Linux servers

We use Django, Python, PHP (only when we have to), jQuery, and HTML5 to build our sites. We write clean, handcrafted semantic markup with a strong focus on usability.

Requirements

• Django, Python, PHP, MySql, Git, Fabric, South, Facebook Graph API, Semantic HTML, JavaScript, Apache/Nginx, Linux Administration
• Sample URL's or portfolio
• 3+ years experience
• Strong interest in current development trends
• Organized, detail-oriented, able to multi-task
• Able to work autonomously, without day-to-day project management guidance or deadline tracking
• Must have an appreciation for design aesthetics and experience working with a design team.

A strong preference will be given to applicants open to filling the job in Kansas City, but Chicago will also be considered.

Send your resume to developer@liquid9.tv

Saturday, Kansas City Python coders finally came out of their basements to meet and discuss the first ever broad-scale Python user group in Kansas City.

After months of brewing interest in a Python meetup, curiosity about the existence and occupation of local Python developers, and discussions with the Python Software Foundation about hosting a future PyCon in Kansas City, the Python KC user group was born.

The meeting was well-attended, and we were honored and humbled to be able to host the first discussion at Liquid 9. In attendance were some brilliant minds, from the founder of the zero-knowledge data encryption, backup, sync, and storage service SpiderOak, to a developer of the mobile media platform MobiTV, which serves up hundreds of shows for television giants NBC, Fox News, ESPN, The Disney Channel, and Comedy Central.

The diversity of ways developers are using Python in Kansas City really gave credence to the power and flexibility of the language, and made it clear that a user group such as this would be beneficial to us all, and to the Kansas City programming community at large. It was great also to see a handful of attendees who had never touched Python code at all, but just had curiosity about the merits of the language and wanted to learn a bit more.

Some of the key goals discussed in the meeting:

• Raise awareness and interest in the Python programming language
• Find "sell-able" ways to demonstrate the business value of the language, even on an enterprise level, to broaden the acceptance of the language in corporate environments
• Learn new ideas and concepts about the language we love

It will be a fun road to see how this group evolves over time.

def init_user_group():
    meet_and_discuss()
    for today in forever:
        users = [user.name for user in local_developers if 'Python' in
                 user.interests]
        group = Group(members=','.join(users), activities=lambda day: [
                      user.brings_to_the_table(day) for user in users])
        group.perform_activities(today)

After facing countless frustrations trying to find a way to geocode 300+ addresses to latitude and longitude coordinates for an upcoming project, I decided to investigate scripting Google Spreadsheets to handle the task.

The ImportData() solution that has been spread around is clever, but, unfortunately, Google limits spreadsheets to 50 or fewer ImportData() formulas per sheet. For situations where many more geocodes are needed, this won't work.

This is where I turned to Google Apps Script for the first time, and I've published a script in the script gallery called "Batch Geocode."

Here's how to use it.

First, open your Google Spreadsheet and select Tools -> Script Gallery. Search for "Batch Geocode," and click "Install."

After installation, you will need to close and re-open your spreadsheet. Upon re-opening, you will find a "Geocoder" menu added up top.

Prepare your data for geocoding. For my spreadsheet, I had to concatenate several fields first to get a valid location field.

After copying the formula down the spreadsheet, I had complete addresses ready for geocoding.

Next, hightlight the addresses you want geocoded, and select "Geocode addresses" from the "Geocoder" menu.

You will be prompted for which columns you would like to overwrite with the latitude and longitude values, respectively. These should be two column letters, separated by a comma. If you would like to insert new columns for the data, leave this field blank. Press "OK."

That's all there is to it. The script throttles the process to a maximum of 5 geocoding requests per second, to ease the burden on Google servers and avoid rate limits, so you may have to wait a bit.

However, you will be notified once the script has completed, and your latitude and longitude values will appear in the specified columns!

Until the script has been approved by Google for addition to the script gallery, the raw script can be downloaded here, and installed manually through your spreadsheet's script editor.