Read, then Write CSV with "Non-ISO extended-ASCII" text Encoding

See also questions close to this topic

• PermissionError: [WinError 32] for GridSearchCV in spyder

  param_test1 = {'n_estimators':range(20,81,10)}
  gsearch1 = GridSearchCV(estimator = GradientBoostingClassifier(learning_rate=0.1, 
                                                                 min_samples_split=500,
                                                                 min_samples_leaf=50,
                                                                 max_depth=8,
                                                                 max_features='sqrt',
                                                                 subsample=0.8,
                                                                 random_state=10), 
                                                    param_grid = param_test1, 
                                                                 scoring='roc_auc',
                                                                 n_jobs=4,
                                                                 iid=False, 
                                                                 cv=5)
  
  
  gsearch1.fit(train[predictors],train[target]) #getting error on this line
  

  Error:PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\Users\xx\AppData\Local\Temp\joblib_memmapping_folder_xx\xx-xx-xx.pkl'

  Windows 10 Python 3.6.4 sklearn.version Out[26]: '0.20.2'

  Please let me know how to fix this error
• Can't print .md file from os.listdir array

  I need to create function that can jump to directories and I make it by os.listdir that show files and paths. Then user choose one of the following files and paths to jump. By the way, there is a problem. I want to print chosen element and it works but i can print README.md.

  Then i tried to add another file that located below. I've noticed that i can't choose the last file in the directory.

  def folder_inspector():
      import os
      folder_container = os.listdir()
      for i in range(len(folder_container)):
          print(str(i + 1) + ". " + folder_container[i])
      folder_element = int(input("Select folder > "))
      if folder_element in range(len(folder_container)):
          folder_container_index = folder_element - 1
          print(folder_container[folder_container_index])
      folder_inspector()
  

  what it prints:

  1. .git
  2. .gitattributes
  3. kek
  4. main.py
  5. README.md
  6. zz.md
  Select folder > 6
  

  Program doesn't print sixth file (zz.md) and then stops.
• Queue returns values only in parent module

  I don't understand why it happens, but my thread returns value only if run it in it's parent module.

  My method. I've excluded SQL statement, but I'm 100% sure it works. result is a lits of dictionaries, so it's a one value variable.

  def _transits_data(self,zone_id, interval, queue):
       while datetime.now() >= session_interval:
              result = SQLConnector().query(statement, zone_id, interval, interval, fetch=True)
              queue.put(result)
  

  Next I start my thread

  def start(self, zone_id, interval):
          queue = Queue()
          self.transits_list =Thread(target=self._transits_data, args=(zone_id, interval, queue))
          return queue.get()
  

  So if I run it in the same module

  if __name__ == '__main__':
      transits_listener = TransitsListener()
      result = transits_listener.start(zone_id, interval)
      print(result)
  

  I receive a list of dicts as expected, but if I import it in another module application.py:

  class Application
     def __init__(self):
         self.transits_listener = TransitsListener()
     def run(self):
         transits_list = self.transits_listener(zone_id, interval)
         print(transits_list)
  if __name__ == '__main__':
    app = Application()
    app.run()
  

  I receive only an empty list.
• Accessing a python module from S3

  I am having a custom module and want to access it in my databricks python language. When I tried using sys.path, it was not working. Could someone please help me to access it from s3 to databricks.
• how to align image with specific positon and size in openpyxl

  I have generated an excel with openpyxl package. In that one column contain an multiple link for attachments and that attachment can be anything like document or image. each cell in the column contains more than one url. I have parse the url for image and already generated the image for each url. My problem is, the images are overlapping. I want to fix thier position in cell. I don't know how to do that. I also try to align but no use.

  http = urllib3.PoolManager()
  r = http.request('GET', aa[j])
  image_file = io.BytesIO(r.data)
  img = Image(image_file)
  img.height=100
  img.width =100[enter link description here][1]
  ws.add_image(img,'G'+str(new_row))
  

  above is my code to add image to excel. aa[j] are the image url.