old_contents: # Copyright 2018 Google LLC
  #
  # Licensed under the Apache License, Version 2.0 (the "License");
  # you may not use this file except in compliance with the License.
  # You may obtain a copy of the License at
  #
  #     http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing, software
  # distributed under the License is distributed on an "AS IS" BASIS,
  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  # See the License for the specific language governing permissions and
  # limitations under the License.
  
  # [START sheets_quickstart]
  from __future__ import print_function
  from googleapiclient.discovery import build
  from httplib2 import Http
  from oauth2client import file, client, tools
  
  # If modifying these scopes, delete the file token.json.
  SCOPES = 'https://www.googleapis.com/auth/spreadsheets.readonly'
  
  # The ID and range of a sample spreadsheet.
  SAMPLE_SPREADSHEET_ID = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'
  SAMPLE_RANGE_NAME = 'Class Data!A2:E'
  
  def main():
      """Shows basic usage of the Sheets API.
      Prints values from a sample spreadsheet.
      """
      store = file.Storage('token.json')
      creds = store.get()
      if not creds or creds.invalid:
          flow = client.flow_from_clientsecrets('credentials.json', SCOPES)
          creds = tools.run_flow(flow, store)
      service = build('sheets', 'v4', http=creds.authorize(Http()))
  
      # Call the Sheets API
      SPREADSHEET_ID = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'
      RANGE_NAME = 'Class Data!A2:E'
      result = service.spreadsheets().values().get(spreadsheetId=SPREADSHEET_ID,
                                                  range=RANGE_NAME).execute()
      values = result.get('values', [])
  
      if not values:
          print('No data found.')
      else:
          print('Name, Major:')
          for row in values:
              # Print columns A and E, which correspond to indices 0 and 4.
              print('%s, %s' % (row[0], row[4]))
  
  if __name__ == '__main__':
      main()
  # [END sheets_quickstart]
  
new_contents: # Copyright 2018 Google LLC
  #
  # Licensed under the Apache License, Version 2.0 (the "License");
  # you may not use this file except in compliance with the License.
  # You may obtain a copy of the License at
  #
  #     http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing, software
  # distributed under the License is distributed on an "AS IS" BASIS,
  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  # See the License for the specific language governing permissions and
  # limitations under the License.
  
  # [START sheets_quickstart]
  from __future__ import print_function
  from googleapiclient.discovery import build
  from httplib2 import Http
  from oauth2client import file, client, tools
  
  # If modifying these scopes, delete the file token.json.
  SCOPES = 'https://www.googleapis.com/auth/spreadsheets.readonly'
  
  # The ID and range of a sample spreadsheet.
  SAMPLE_SPREADSHEET_ID = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'
  SAMPLE_RANGE_NAME = 'Class Data!A2:E'
  
  def main():
      """Shows basic usage of the Sheets API.
      Prints values from a sample spreadsheet.
      """
      store = file.Storage('token.json')
      creds = store.get()
      if not creds or creds.invalid:
          flow = client.flow_from_clientsecrets('credentials.json', SCOPES)
          creds = tools.run_flow(flow, store)
      service = build('sheets', 'v4', http=creds.authorize(Http()))
  
      # Call the Sheets API
      sheet = service.spreadsheets()
      result = sheet.values().get(spreadsheetId=SAMPLE_SPREADSHEET_ID,
                                  range=SAMPLE_RANGE_NAME).execute()
      values = result.get('values', [])
  
      if not values:
          print('No data found.')
      else:
          print('Name, Major:')
          for row in values:
              # Print columns A and E, which correspond to indices 0 and 4.
              print('%s, %s' % (row[0], row[4]))
  
  if __name__ == '__main__':
      main()
  # [END sheets_quickstart]
  
subject: Consolidate redundant variables