json pandas 内存溢出_Python Pandas合并导致内存溢出

I'm new to Pandas and am trying to merge a few subsets of data. I'm giving a specific case where this happens, but the question is general: How/why is it happening and how can I work around it?

The data I load is around 85 Megs or so but I often watch my python session run up close to 10 gigs of memory usage then give a memory error.

I have no idea why this happens, but it's killing me as I can't even get started looking at the data the way I want to.

Here's what I've done:

Importing the Main data

import requests, zipfile, StringIO

import numpy as np

import pandas as pd

STAR2013url="http://www3.cde.ca.gov/starresearchfiles/2013/p3/ca2013_all_csv_v3.zip"

STAR2013fileName = 'ca2013_all_csv_v3.txt'

r = requests.get(STAR2013url)

z = zipfile.ZipFile(StringIO.