Kickstarter JSON数据解析，保存csv

#!/usr/bin/python
# -*- encoding: utf-8 -*-
import json
import csv

if __name__ == '__main__':     
    file_object = open("Kickstarter_2019-01-17T03_20_02_630Z.json",'rb')
    all_the_text = file_object.read()  #结果为str类型
    print (len(all_the_text))
    #print ("all_the_text=",all_the_text)
    file_object.close()

    log_path = 'result.csv'
    file = open(log_path, 'a+', encoding='utf-8', newline='')
    csv_writer = csv.writer(file)
    csv_writer.writerow(['backers_count', 
        'blurb',	
        'category',	
        'converted_pledged_amount',	
        'country',	
        'country_displayable_name',	
        'created_at',
        'creator',
        'currency',
        'currency_symbol',	
        'currency_trailing_code',	
        'current_currency',	
        'deadline',	
        'disable_communication',	
        'friends',	
        'fx_rate',	
        'goal',	
        'id',	
        'is_backing',	
        'is_starrable',	
        'is_starred',	
        'launched_at',	
        'location',	
        'name',	
        'permissions',	
        'photo',	
        'pledged',	
        'profile',	
        'slug',	
        'source_url',	
        'spotlight',	
        'staff_pick',	
        'state',	
        'state_changed_at',	
        'static_usd_rate',
        'urls',	
        'usd_pledged',
        'usd_type'])  

    begin_index = all_the_text.find("{\"table_id\"".encode())
    while begin_index != -1:
        end_index = all_the_text.find("{\"table_id\"".encode(), begin_index + 1)
        if -1 == end_index:
            per_json = all_the_text[begin_index : ]
        else:
            per_json = all_the_text[begin_index : end_index]

        
        per_json.replace(b'\n', b'')
        print(per_json)
        print('\n\n')

        obj_json = json.loads(per_json)
        obj_data = obj_json.get('data')
        backers_count = obj_data.get('backers_count')
        blurb = obj_data.get('blurb')	
        category = obj_data.get('category')	
        category = json.dumps(category)	
        converted_pledged_amount = obj_data.get('converted_pledged_amount')		
        country = obj_data.get('country')			
        country_displayable_name = obj_data.get('')	  #国家的全称，上面是缩写		
        created_at = obj_data.get('created_at')		
        creator = obj_data.get('creator')	
        creator = json.dumps(creator)	
        currency = obj_data.get('currency')			
        currency_symbol = obj_data.get('currency_symbol')			
        currency_trailing_code = obj_data.get('currency_trailing_code')	#是否要转大写		
        current_currency = obj_data.get('current_currency')			
        deadline = obj_data.get('deadline')			
        disable_communication = obj_data.get('disable_communication')			
        friends = obj_data.get('friends') #可能没有这个值			
        fx_rate = obj_data.get('fx_rate')			
        goal = obj_data.get('goal')		
        id = obj_data.get('id')			
        is_backing = obj_data.get('is_backing')	#可能没有这个值		
        is_starrable = obj_data.get('is_starrable')  #是否要转大写	.upper()			
        is_starred = obj_data.get('is_starred')  #是否要转大写	.upper()				
        launched_at = obj_data.get('launched_at')			
        location = obj_data.get('location')
        location = json.dumps('location')			
        name = obj_data.get('name')			
        permissions = obj_data.get('permissions')			
        photo = obj_data.get('photo')	
        photo = json.dumps('photo')		
        pledged = obj_data.get('pledged')			
        profile = obj_data.get('profile')	
        profile = json.dumps('profile')

        slug = obj_data.get('slug')			
        source_url = obj_data.get('source_url')			
        spotlight = obj_data.get('spotlight')			
        staff_pick = obj_data.get('staff_pick')			
        state = obj_data.get('state')			
        state_changed_at = obj_data.get('state_changed_at')			
        static_usd_rate = obj_data.get('static_usd_rate')		
        urls = obj_data.get('urls')	
        urls = json.dumps('urls')		
        usd_pledged = obj_data.get('usd_pledged')			
        usd_type = obj_data.get('usd_type')	
        begin_index = end_index

        csv_writer.writerow([backers_count, 
            blurb,	
            category,	
            converted_pledged_amount,	
            country,	
            country_displayable_name,	
            created_at,
            creator,
            currency,
            currency_symbol,	
            currency_trailing_code,	
            current_currency,	
            deadline,	
            disable_communication,	
            friends,	
            fx_rate,	
            goal,	
            id,	
            is_backing,	
            is_starrable,	
            is_starred,	
            launched_at,	
            location,	
            name,	
            permissions,	
            photo,	
            pledged,	
            profile,	
            slug,	
            source_url,	
            spotlight,	
            staff_pick,	
            state,	
            state_changed_at,	
            static_usd_rate,
            urls,	
            usd_pledged,
            usd_type])

       

#         with open(CVS_FILE_NAME, 'wb') as csvfile:
#             spamwriter = csv.writer(csvfile,dialect='excel')        
#             spamwriter.writerow([u'序号'.encode('gbk'), u'姓名'.encode('gbk'), u'电话'.encode('gbk'), u'访问时间'.encode('gbk'), u'IP位置'.encode('gbk'), u'渠道名称'.encode('gbk')])
#             for item in listRes:
#                 spamwriter.writerow([str(item['num']), item['name'].encode('gbk'), item['tel'], item['createdate'], item['iplocation'].encode('gbk'), item['channel'].encode('gbk')])

    print('\n\n end-------------------------------------------------') 
    file.close()