Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: utf-8 -*-
- import sys
- import csv
- import io
- import pandas as pd
- import os
- reload(sys)
- sys.setdefaultencoding("utf-8")
- os.chdir
- def main():
- fileReader = 'output.csv'
- fileClient = 'm_client_data.csv'
- fileCorporate = 'm_corporate_client_data.csv'
- fileNeither = 'm_neither_data.csv'
- header_corporate = [
- "name",
- "tel_number_1",
- "tel_number_2",
- "e_mail_address_1",
- "e_mail_address_2",
- "zip_code",
- "address_1",
- "address_2",
- "address_3",
- "address_4",
- "nearest_station",
- "business_category",
- "officer_name",
- "department",
- "memo",
- "created_by",
- "updated_by",
- "created_at",
- "updated_at",
- "deleted"
- ]
- header_client = [
- "last_name",
- "first_name",
- "last_name_kana",
- "first_name_kana",
- "liner_user_id",
- "verify_code",
- "tel_number_1",
- "tel_number_2",
- "e_mail_address_1",
- "e_mail_address_2",
- "zip_code",
- "address_1",
- "address_2",
- "address_3",
- "address_4",
- "gender",
- "date_of_birth",
- "memo",
- "created_by",
- "updated_by",
- "created_at",
- "updated_at",
- "deleted",
- "fax_number",
- "age",
- "profession",
- "station_of_employment",
- "employment"
- ]
- header_neither = ["unknown_client_info"]
- def writerForClient(fileReader, fileClient, header_client):
- with open(fileClient, "w+", newline = "") as x:
- client = csv.writer(x, delimiter=',')
- client.writerow(header_client)
- client.write
- def writerForCorporate(fileReader, fileCorporate, header_corporate):
- with open(fileCorporate, "w+", newline = "") as f:
- corporate = csv.writer(f, delimiter=',')
- corporate.writerow(header_corporate)
- selector(fileReader)
- def writerForNeither(fileReader, fileNeither, header_neither): #kojin and hojin 以外の場合, それ用のcsv file を出力させる
- with open(fileNeither, "w+", newline = "") as n:
- neither = csv.writer(n, delimiter=',')
- neither.writerow(header_neither)
- def selector(fileReader):
- client_list = [] #個人顧客用 temp 2D array
- corporate_list = [] #法人顧客用 temp 2D array
- neither_list = [] #どちらでもない temp 2D array
- with open('output.csv') as f:
- fileReader = csv.reader(f)
- temp_row = [i for i in fileReader]
- if temp_row[i][31] == 'hojin':
- corporate_list.append(temp_row[i])
- elif temp_row[i][31] == 'kojin':
- client_list.append(temp_row[i])
- else:
- neither_list.append(temp_row[i])
- return corporate_list, client_list, neiether_list
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement