Decorators in Python

 https://www.youtube.com/c/uwcse/playlists

 http://demo.clab.cs.cmu.edu/11711fa20/ https://www.kdnuggets.com/2019/10/10-free-top-notch-courses-natural-language-processing.html

 https://www.dropbox.com/s/5a8w8kckyfeaix0/statistical%20models%20-%20diagram.pdf?dl=0 https://www.linkedin.com/posts/adrianolszewski_rockyourr-datascience-dataanalysis-activity-6691521288101531648-jkuW

  default Dict

 https://hackernoon.com/understanding-the-underscore-of-python-309d1a029edc

 https://towardsdatascience.com/knowing-these-you-can-cover-99-of-file-operations-in-python-84725d82c2df

As python have the rich set of library for doing task automation when it comes to file transfer over FTP server there are many libraries available in python like ftplib, ftputil, paramiko, fabric etc. In this article, i am going to explain that how you can use ftplib python library for file transfer over an FTP server.   Using ftplib library you can perform a variety of FTP jobs automation, You can seamlessly connect to an FTP server to retrieving files and manipulate them locally.   1 2 3 4 5 6 7 8 9 10 11 12 from ftplib import FTP ftp_obj = FTP ( )   serveruri = '192.168.1.199' serverport = '21' ftp . connect ( serveruri , serverport )   serveruser = 'ftp-test' serverpassword = 'ftp-test12#' ftp_obj . login ( user = serveruser , passwd = serverpassword )   ftp_obj . retrlines ( 'LIST' ) # list directory contents ########################################## FTP Methods: ==>FTP.connect(host[, port[, timeout]]) This use to establish a c...

SQL Concepts Question and Solution  CTE Window Functions Types of Window functions Aggregate Window Functions SUM(), MAX(), MIN(), AVG(). COUNT() Ranking Window Functions RANK(), DENSE_RANK(), ROW_NUMBER(), NTILE() Value Window Functions LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE() ALL ALL is an optional keyword. When you will include ALL it will count all values including duplicate ones. DISTINCT is not supported in window functions ex: SELECT order_id , order_date , customer_name , city , order _ amount , MAX ( order_amount ) OVER ( PARTITION BY city ) as maximum_order_amount FROM [ dbo ] . [ Orders ] ex: 3 4 5   SELECT order_id , order_date , customer_name , city , order_amount , DENSE_RANK ( ) OVER ( ORDER BY order_amount DESC ) [ Rank ] FROM [ dbo ] . [ Orders ] ex: ROW_NUMBER() with PARTITION BY 1 2 3 4 5   SELECT order_id , order_date , customer_name , city , order_amount , ROW_NUMBER ( ) OVER ( PARTITION BY city ORDER BY order_amount DESC ) [ row_nu...