[에이블런] [AI 스타트업 유니버시티] 0716 TIL

ChatGPT

 

 

 

 

 

[내 GPT 만들기]

 

 

 

 

[airtable]

 

 

 

 

- favorite로 테이블 명을 변경

- 변수명을 지정 후 특성 변환

- 데이터 입력하기

 

 

 

 

GPTs Action key 등록

 

 

API에 대한 스키마 생성

openapi: 3.1.0
info:
  title: Airtable API
  description: API for interacting with Airtable.
  version: 1.0.0
servers:
  - url: https://api.airtable.com/v0
    description: Airtable API server
paths:
  /{baseId}/{tableIdOrName}:
    get:
      operationId: listTable1Records
      summary: List records in Table 1
      description: >
        Lists records in Table 1. You can use table names and table ids interchangeably.
        Only non-empty fields are included in the response.
      parameters:
        - name: baseId
          in: path
          required: true
          schema:
            type: string
          description: The ID of the Airtable base.
        - name: tableIdOrName
          in: path
          required: true
          schema:
            type: string
          description: The ID or name of the table.
        - name: fields
          in: query
          schema:
            type: array
            items:
              type: string
          description: >
            Only data for fields whose names or ids are in this list will be included in the result.
        - name: filterByFormula
          in: query
          schema:
            type: string
          description: >
            A formula used to filter records.
        - name: maxRecords
          in: query
          schema:
            type: integer
          description: >
            The maximum total number of records that will be returned in your requests.
        - name: pageSize
          in: query
          schema:
            type: integer
          description: >
            The number of records returned in each request. Must be less than or equal to 100.
        - name: sort
          in: query
          schema:
            type: array
            items:
              type: object
              properties:
                field:
                  type: string
                direction:
                  type: string
                  enum: [asc, desc]
          description: >
            A list of sort objects that specifies how the records will be ordered.
        - name: view
          in: query
          schema:
            type: string
          description: >
            The name or ID of a view in the Table 1 table.
        - name: cellFormat
          in: query
          schema:
            type: string
            enum: [json, string]
          description: >
            The format that should be used for cell values.
        - name: timeZone
          in: query
          schema:
            type: string
          description: >
            The time zone that should be used to format dates when using string as the cellFormat.
        - name: userLocale
          in: query
          schema:
            type: string
          description: >
            The user locale that should be used to format dates when using string as the cellFormat.
        - name: returnFieldsByFieldId
          in: query
          schema:
            type: boolean
          description: >
            An optional boolean value that lets you return field objects where the key is the field id.
        - name: recordMetadata
          in: query
          schema:
            type: array
            items:
              type: string
          description: >
            An optional field that, if includes commentCount, adds a commentCount read only property on each record returned.
      responses:
        '200':
          description: A JSON array of records
          content:
            application/json:
              schema:
                type: object
                properties:
                  records:
                    type: array
                    items:
                      type: object
                      properties:
                        id:
                          type: string
                        createdTime:
                          type: string
                          format: date-time
                        fields:
                          type: object
        '401':
          description: >
            Unauthorized. Request failed due to invalid or missing API key.
          content:
            application/json:
              schema:
                type: object
                properties:
                  error:
                    type: string
        '422':
          description: >
            Request failed due to LIST_RECORDS_ITERATOR_NOT_AVAILABLE or other issues.
          content:
            application/json:
              schema:
                type: object
                properties:
                  error:
                    type: string
components:
  securitySchemes:
    apiKeyAuth:
      type: apiKey
      in: header
      name: Authorization
security:
  - apiKeyAuth: []

 

[테스트]

 

 

 

 

[오렌지]

 

 

train과 test 데이터의 경향성이 비슷하면 그대로 진행

 

 

 

gradient boosting 모델을 통한 모델링

 

 

 

 

[confusion matrix]

 

 

[logistic regression]

 

 

 

=> gradient boosting / logistic regression 결과를 비교하여 더 좋은 모델을 선정