Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 3.58 KB | None | 0 0
  1. # -*- coding: utf-8 -*-
  2. import sys
  3. import csv
  4. import io
  5. import pandas as pd
  6. import os
  7.  
  8. reload(sys)
  9. sys.setdefaultencoding("utf-8")
  10. os.chdir
  11.  
  12. def main():
  13.     fileReader      = 'output.csv'
  14.     fileClient      = 'm_client_data.csv'
  15.     fileCorporate   = 'm_corporate_client_data.csv'
  16.     fileNeither     = 'm_neither_data.csv'
  17.     header_corporate = [
  18.                         "name",
  19.                         "tel_number_1",
  20.                         "tel_number_2",
  21.                         "e_mail_address_1",
  22.                         "e_mail_address_2",
  23.                         "zip_code",
  24.                         "address_1",
  25.                         "address_2",
  26.                         "address_3",
  27.                         "address_4",
  28.                         "nearest_station",
  29.                         "business_category",
  30.                         "officer_name",
  31.                         "department",
  32.                         "memo",
  33.                         "created_by",
  34.                         "updated_by",
  35.                         "created_at",
  36.                         "updated_at",
  37.                         "deleted"
  38.                         ]
  39.     header_client = [
  40.                      "last_name",
  41.                      "first_name",
  42.                      "last_name_kana",
  43.                      "first_name_kana",
  44.                      "liner_user_id",
  45.                      "verify_code",
  46.                      "tel_number_1",
  47.                      "tel_number_2",
  48.                      "e_mail_address_1",
  49.                      "e_mail_address_2",
  50.                      "zip_code",
  51.                      "address_1",
  52.                      "address_2",
  53.                      "address_3",
  54.                      "address_4",
  55.                      "gender",
  56.                      "date_of_birth",
  57.                      "memo",
  58.                      "created_by",
  59.                      "updated_by",
  60.                      "created_at",
  61.                      "updated_at",
  62.                      "deleted",
  63.                      "fax_number",
  64.                      "age",
  65.                      "profession",
  66.                      "station_of_employment",
  67.                      "employment"
  68.                      ]
  69.     header_neither = ["unknown_client_info"]
  70.  
  71. def writerForClient(fileReader, fileClient, header_client):
  72.     with open(fileClient, "w+", newline = "") as x:
  73.         client = csv.writer(x, delimiter=',')
  74.         client.writerow(header_client)
  75.         client.write
  76.  
  77. def writerForCorporate(fileReader, fileCorporate, header_corporate):
  78.     with open(fileCorporate, "w+", newline = "") as f:
  79.         corporate = csv.writer(f, delimiter=',')
  80.         corporate.writerow(header_corporate)
  81.         selector(fileReader)
  82.  
  83. def writerForNeither(fileReader, fileNeither, header_neither): #kojin and hojin 以外の場合, それ用のcsv file を出力させる
  84.     with open(fileNeither, "w+", newline = "") as n:
  85.         neither = csv.writer(n, delimiter=',')
  86.         neither.writerow(header_neither)
  87.  
  88. def selector(fileReader):
  89.     client_list = [] #個人顧客用 temp 2D array
  90.     corporate_list = [] #法人顧客用 temp 2D array
  91.     neither_list = [] #どちらでもない temp 2D array
  92.     with open('output.csv') as f:
  93.         fileReader = csv.reader(f)
  94.         temp_row = [i for i in fileReader]
  95.         if   temp_row[i][31] == 'hojin':
  96.             corporate_list.append(temp_row[i])
  97.         elif temp_row[i][31] == 'kojin':
  98.             client_list.append(temp_row[i])
  99.         else:
  100.             neither_list.append(temp_row[i])
  101.  
  102.     return corporate_list, client_list, neiether_list
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement