How to change all file names in folder?

See also questions close to this topic

• How do I take only specified required columns from CSV file and add into a table in postgresql?

  Consider I have

  *----*------*-----------*----------*----------*---------------*----------------*
  | id | name | addressid | address1 | address2 | attendancekey | attendancedate |
  *----*------*-----------*----------*----------*---------------*----------------*
  

  columns in CSV file and I want only

  1. id, name to be imported in student table and

  2. addressid, address1, address2 to be imported in address table and

  3. attendancekey and attendancedate to be imported in attendance table in database.

  What query to be used to import the required columns into the table?

  Database Postgresql Version - 12

  Python Version - 3.4.4

  Psycopg2 Version - 2.7.5
• Minimizing SQL OLE calls to Python Socket - Removing headers

  I currently have a Service written in Python that accepts web calls and returns information. Since these are fully formatted web calls there are http headers in both the request and the response. These calls are made frequently and in bulk. Due to the size of the request and response, the headers make up nearly 50% of our network traffic.

  Since this is not a service being exposed to the clients I am looking to transmit only the request (123) and return the response (456). The code below has been designed to demonstrate the basic techniques and give an example of the issue. It is not indicative of our full process.

  Simple Python Socket:

  import socket
  
  
  MAX_PACKET = 32768
  PORT = 9879
  IP = '127.0.0.1'
  
  
  def open_sockets():
  
      current_socket = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
      current_socket.bind((IP, PORT))
      print(f"Socket bound to I.P. {IP} : port {PORT}")
  
      current_socket.listen(5)
      print("Open sockets - Socket is listening")
      print("-" * 80)
  
      while True:
          client_socket, address = current_socket.accept()
          request = client_socket.recv(MAX_PACKET).decode("utf-8")
          print(request)
          response_text = 456
          response_to_send = f'HTTP/1.0 200 OK \nContent-Type: text/html \n\n{response_text}'.encode('utf-8')
          client_socket.send(response_to_send)
          client_socket.close()
  
  
  if __name__ == '__main__':
      open_sockets()
  

  OLE Call from SQL (SQL Server 2016)

  DECLARE @URL   NVARCHAR(MAX)
  ,       @ret   INT
  ,       @token INT;
  
  SET @URL = N'http://127.0.0.1:9879/request=123';
  
  EXECUTE @ret = sp_OACreate 'MSXML2.ServerXMLHTTP', @token OUTPUT;
  IF @ret <> 0    RAISERROR('Unable to create HTTP connection.', 10, 1);
  
  EXECUTE @ret = sp_OAMethod @token, 'open', NULL, 'GET', @URL, False;
  IF @ret <> 0    RAISERROR('Unable to open HTTP connection.', 10, 1);
  
  EXECUTE @ret = sp_OAMethod @token, 'send';
  IF @ret <> 0    RAISERROR('Unable to send HTTP command.', 10, 1);
  
  EXECUTE @ret = sp_OAGetProperty @token, 'responseText';
  IF @ret <> 0    RAISERROR('Unable to read from http.', 10, 1);
  
  EXEC sp_OADestroy @token;
  

  While the socket is running, if I execute the SQL call I get the following results:

  From Python:

  Socket bound to I.P. 127.0.0.1 : port 9879
  Open sockets - Socket is listening
  --------------------------------------------------------------------------------
  GET /request=123 HTTP/1.1
  Connection: Keep-Alive
  Accept: */*
  Accept-Language: en-GB,en;q=0.5
  User-Agent: Mozilla/4.0 (compatible; Win32; WinHttp.WinHttpRequest.5)
  Host: 127.0.0.1:9879
  

  From SQL:

  Column1
  -------
  456
  
  (1 row affected)
  

  As you can see the content being is only a minor part of the data. And while the "real-world" calls and responses are a bit larger, the header info is a significant proportion. Especially on the request. In this case message length is 192 characters, of which 3 characters are actual content.

  Is there a more efficient call, ole component object, access method etc. available in SQL to help me minimize the network traffic?
• Is there any way to reference the current iteration of a comprehension?

  I have a list of dictionaries that represent different individuals' answers to a survey, with each dictionary being a new person {question:answer, etc.}.

  I'm trying to only add a user's answer to their age on a survey as the value of a new dictionary only if they answered as being male or female in another question. D is the list of dictionaries and I want to traverse through the entire list but I don't know how to reference a specific dictionary while in the comprehension loop.

  My goal is to do so so that I can check if the value of 'Gender' in the current dictionary is 'Male' and then add the answer to the age question to my new dictionary.

  def train(D, gender, lookingFor):     #lookingFor = ('Ageyears', 'Region')
      D1 = {}                           #gender = ['Male', 'Female']
      D2 = {}
  
  
  
  
      for i in gender:
          for x in lookingFor:
              ageDict = [sub[x] for sub in D if D[***CURRENT ITERATION***][age] == i]
  
              D2[x] = dict.fromkeys(ageDict, 0)
  
          D1[i] = D2
  
      print(D1)
  

  I need to know what to put in place of [***CURRENT ITERATION***] so that I can reference the current dictionary.

  Here is the data:

  [
      OrderedDict([('Country', 'USA'), ('Region', 'OK'), ('Gender', 'Female'), ('Ageyears', 16), ('Handed', 'Right-Handed'), ('Height_cm', 169)]), 
      OrderedDict([('Country', 'USA'), ('Region', 'GA'), ('Gender', 'Female'), ('Ageyears', 18), ('Handed', 'Left-Handed'), ('Height_cm', 165.1)]),
      OrderedDict([('Country', 'USA'), ('Region', 'NJ'), ('Gender', ''), ('Ageyears', ''), ('Handed', ''), ('Height_cm', '')]),
  ]