Answer My Searches

svn – Revision 4862: /xlwt/trunk/xlwt/examples
Useful examples of how to use the Python Excel library, xlwt.

The equivalent of Python’s repr in perl
use Data::Dumper;
$boo = ” test n”;
print Dumper($boo);

Preserving styles using python’s xlrd,xlwt, and xlutils.copy – Stack Overflow
Python Excel (xlrd, xlwt) – How to copy a style from one cell and put it on another:

newCell.xf_idx = previousCell.xf_idx

New JDBC Drivers for FileMaker 11
I was getting these errors trying to connect to FileMaker 11 via JDBC on DBVisualizer. It turns out you need this new JDBC driver.

Product: DbVisualizer Personal 7.1.5
Build: #1590 (2011/02/24 17:23)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.6.0_26
Java Vendor: Apple Inc.
OS Name: Mac OS X
OS Arch: x86_64
OS Version: 10.6.8

An error occurred while establishing the connection:

Long Message:
[DataDirect][SequeLink JDBC Driver]Internal network error, session aborted due to session protocol data unit format error, connection closed.

Details:
   Type: java.sql.SQLException
   Error Code: 2207
   SQL State: HY000

1) Nested Exception:

Long Message:
Session aborted due to IIOP problems.

Details:
   Type: java.sql.SQLException
   Error Code: 7772
   SQL State: HY000

2) Nested Exception:

Long Message:
IIOP error, invalid protocol identifier.

Details:
   Type: java.sql.SQLException
   Error Code: 7529
   SQL State: HY000

Mean and Standard Deviation in Python
8.3 meanstdv()

Summary
Mean and standard deviation of data

Usage
real, real = meanstdv(list)

“”" Calculate mean and standard deviation of data x[]: mean = {sum_i x_i over n} std = sqrt(sum_i (x_i – mean)^2 over n-1) “”" def meanstdv(x): from math import sqrt n, mean, std = len(x), 0, 0 for a in x: mean = mean + a mean = mean / float(n) for a in x: std = std + (a – mean)**2 std = sqrt(std / float(n-1)) return mean, std

File Requires “Full Access” to login. – FileMaker Forums – FileMaker Pro Help and Support Worldwide Community
How to fix FileMaker error:
“your access privileges do not allow you to perform this action” when logging in with a non-full-access account.

You simply want to add the extended privilege “Access via FileMaker Network (fmapp)” to make this work

Statistical Computing with R: A tutorial
This is a refreshingly straight-forward R tutorial. The first I’ve seen.

Requests: HTTP for Humans — Requests 0.6.2 (dev) documentation
Most existing Python modules for sending HTTP requests are extremely verbose and cumbersome. Python’s builtin urllib2 module provides most of the HTTP capabilities you should need, but the api is thoroughly broken. It requires an enormous amount of work (even method overrides) to perform the simplest of tasks.

Things shouldn’t be this way. Not in Python.

Basics: Master Control Genes and Pax-6 : Pharyngula
A very interesting discussion of master control genes. Did you know you can take a single squid gene, put it into a fly cell, and have it create a fly eye?

R Tutorials
These are supposed to be good R tutorials

The Mouse as a Model System
This somewhat explains why a backcross experiment would be desired or necessary. It also explains some interesting ideas about genetics in general.

Autodesk Labs Utilities Project Photofly 2.1
Allows anyone with a digital camera to create near accurate 3D models from photographs using the web.

Django Model Field to MySQL Datatype – The Glenbot
This page tells you what MySQL datatype each Django model field type uses … as of 2009. It’s still pretty handy.
My search term was “django time field mysql datatype”

python – Django and SSL question – Stack Overflow
Setting up SSL with Apache

Show Page Source XML-RPC – Confluence User Community – Atlassian Documentation – Confluence
How to get the contents of a wiki page using Python and xml-rpc.

Switch “origin” of your GIT repository « Dariusz Cieślak’s Blog on Software
I was trying to put my existing, cloned repository into github and I got this error:
$git remote add origin git@github.com:JaneliaSciComp/msg.git
fatal: remote origin already exists.

This page tells how you change your remote origin.

Pro Git – Table of Contents
This seems like a really good online git book.

Perl Warning WTF – Scalar value @t[7] better written as $t[7]
This page has the answer:

The problem is that @names[3] denotes an array slice — you can tell by the @. What you really want is $names[3], which is a true scalar

perl – How can variables be set to NULL under the strict pragma? – Stack Overflow
Fixing warning:
Bareword “null” not allowed while “strict subs” in use

My commentary:
Null isn’t real? The other tutorials said it was. Why is it allowed at all then?

perlintro – perldoc.perl.org
This seems like the best perl tutorial I’ve seen. It’s simple and to the point.

Squeaky floor joist gets a screw — or two – Home, Furniture & Design – ReviewJournal.com
How to fix floor squeaks

‪Auto Repair: Install Power Window Switch Chevy Venture Pontiac Montana 97-05 – 1AAuto.com‬‏ – YouTube
My window switch got stuck on my Chevy venture. I forced it unstuck and now the window won’t go down.

gittutorial(7)
Seems like a pretty reasonable overview of doing a git clone and using git

DjangoResources – Django
This page lists open source projects and applications regarding Django, the framework for perfectionists with deadlines.

Easily packaging and distributing Django apps with setuptools and easy_install | Surfing in Kansas
I always figured it would be near impossible to distribute a Django app. I’ll see what this says though …