Пример #1
0
    def test_meta_files(self):
        acs_meta = ACSMeta()
        self.failUnlessEqual(acs_meta.csv_column_for_matrix('B07401_001'), 6)

        census_meta = CensusMeta('SF1')
        self.failUnlessEqual(census_meta.csv_column_for_matrix('P001001'), 5)

        census_meta = CensusMeta('SF3')
        self.failUnlessEqual(census_meta.csv_column_for_matrix('P021001'), 171)

        census_2010_sf1_meta = Census2010Meta('sf1')
        self.failUnlessEqual(census_2010_sf1_meta.csv_column_for_matrix('P0040002'), 14)
Пример #2
0
    def get_value(self, table, geo_dicts):
        if not isinstance(geo_dicts, list):
            geo_dicts = [geo_dicts]
        census_info = CensusMeta(self.summary_file)
        fileid = 'u%s' % self.summary_file

        col = census_info.csv_column_for_matrix(table)
        raw_vals = Row.objects.filter(
            fileid=fileid,
            cifsn=census_info._file_name_for_matrix(table),
            stusab__in=map(lambda g: g['STUSAB'].upper(), geo_dicts),
            logrecno__in=map(lambda g: g['LOGRECNO'], geo_dicts)
        ).values_list("col%s" % str(col - 4), flat=True)

        return map(lambda v: Value(self._type_value(v)), raw_vals)
Пример #3
0
    def get_value(self, table, geo_dicts, **kwargs):

        if not isinstance(geo_dicts, list):
            geo_dicts = [geo_dicts]
        census_info = CensusMeta(self.summary_file)
        fileid = 'u%s' % self.summary_file

        col = census_info.csv_column_for_matrix(table)

        raw_vals = Row.objects.filter(
            fileid=fileid,
            cifsn=census_info._file_name_for_matrix(table),
            stusab__in=map(lambda g: g['STUSAB'].upper(), geo_dicts),
            logrecno__in=map(lambda g: g['LOGRECNO'],
                             geo_dicts)).values_list("col%s" % str(col - 4),
                                                     flat=True)

        return map(lambda v: Value(self._type_value(v)), raw_vals)
Пример #4
0
    def test_meta_files(self):
        acs_meta = ACSMeta()
        self.failUnlessEqual(acs_meta.csv_column_for_matrix('B07401_001'), 6)

        census_meta = CensusMeta('SF1')
        self.failUnlessEqual(census_meta.csv_column_for_matrix('P001001'), 5)

        census_meta = CensusMeta('SF3')
        self.failUnlessEqual(census_meta.csv_column_for_matrix('P021001'), 171)

        census_2010_sf1_meta = Census2010Meta('sf1')
        self.failUnlessEqual(
            census_2010_sf1_meta.csv_column_for_matrix('P0040002'), 14)