karn | Manage multiple Git identities | Identity Management library

I have a text file from which I want to remove the line break and add a header to convert it to a CSV file.

The file looks like this:

I have a problem statement as follows:

In each examination centre, exam is to be organised in two shifts batch I & batch II(reporting time 9:00 AM & 2 PM). Exam can be conducted at any day in a district during December 1-30, 2020 depending upon the number of candidates in a district. Note in each district only one examination centre is possible and in one shift maximum 20 students can appear. Based on the information mentioned above complete the examination database by allocating:

• Rollno: Roll number of the candidate will start from NL2000001 onwards(eg: NL2000001, NL2000002, NL2000003……)
• cent_allot: allocate centre by putting examination city code
• cent_add: put NL "District Name" as center address in each location (for eg if district name is ADI then centre add is NL ADI)
• examDate: Allocate any exam date between December 1,2020 to December 30, 2020 keeping minimum no of examination days and not violating any conditions mentioned above
• batch: allocate batch I or II ensuring all the conditions mentioned above
• rep_time: for batch I reporting time is 9 AM and for batch II reporting time is 2 PM.

As per the above description, I need to make a table which satisfies the above conditions. I have already made the Rollno, cent_allot and cent_add columns, but I am struggling in making the examDate column, since it should have same date for every 40 values of district.

Here is the list of the districts and their frequency of occurrences:

I want my URL's to show slug instead of id. After following a Youtube video I reached to a stage where admin is automatically creating slugs when I save my products. But still I can not figure out how to show slug in url of detailsview.

I created a utils.py in my project folder which is named as myawesomecart

I have below panads dataframe where I want to compare between a list object(name in a list) of a column with an integer value in another column.

I have the below code which i'm using to parse my data from the text file thats contains the Multiple Fields and hundreds of columns names where i'm choosing the required fields at the time of pandas processing via read_csv which works fine, it it only works with encoding='cp1252' . There are five key fields which i'm looking for as ['Hostname', 'IP Address', 'Aux Site', 'OS Version', 'Network Name'],

In the pattern section which i'm using a variable patt i'm looking for key words/strings as "AIX|CentOS|RHEL|SunOS|SuSE|Ubuntu|Fedora|\?" which i beleive doesn't care about the case sensitiveness. which is get matched into the column OS Version but i'm using the litral ? mark to match the ? which is working but at the same time it also gets the Windows 10 ??? which i only wants ? if its there in the OS Version field.

Secondly, When its converting the df2.to_csv the columns are not delimited rather coming into one which later i'm delimitting manually, How we can ensure that each field is correctly process as a CSV file.

I have a table like below:

I have a large dataset and would like to filter it to only show rows which contain a particular substring (In the following example, 'George') (also bonus points if you tell me how to pass multiple substrings)

For example, if I start with the code

I'm scraping some data from this website enter link description here

After scraping the page, this is the html code I get

I have a called host.txt which further i'm parsing via pandas saving it again with current timestamp.

Below is the code which works fine except timestamp: