shon | The command line argument parser | Command Line Interface library

While I was handling the dataframe in pandas, got some unexpected cells which consists values like-

In some rows, more than one E_name and E_no has been assigned which is supposed to be a single employee in each and every cell My data consists of E_no and E_name both these column needs to be separated in different rows.

What I want is

Seperate those values and put in different rows. Please help me in doing this so that I can proceed further, and it will be really helpful if someone can mention the logic , how to think for this prblm. Thanks in advance.

Let me know if ur facing any kind of difficulty in understanding the prblm

How to run a if block in unix from perl. Eg:

Recently I am building a exam test system and now I have the questions and answers organized as follow in a txt file:

Q1

All of the following are basic components of a security policy EXCEPT the

A. definition of the issue and statement of relevant terms.

B. statement of roles and responsibilities.

C. statement of applicability and compliance requirements.

D. statement of performance of characteristics and requirements.

Answer: D

Explaination: Policies are considered the first and highest level of documentation, from which the lower level elements of standards, procedures, and guidelines flow. This order, however, does not mean that policies are more important than the lower elements. These higher-level policies, which are the more general policies and statements, should be created first in the process for strategic reasons, and then the more tactical elements can follow. -Ronald Krutz The CISSP PREP Guide (gold edition) pg 13

Q2

Ensuring the integrity of business information is the PRIMARY concern of

A. Encryption Security

B. Procedural Security.

C. Logical Security

D. On-line Security

Answer: B

Explaination: Procedures are looked at as the lowest level in the policy chain because they are closest to the computers and provide detailed steps for configuration and installation issues. They provide the steps to actually implement the statements in the policies, standards, and guidelines...Security procedures, standards, measures, practices, and policies cover a number of different subject areas. - Shon Harris All-in-one CISSP Certification Guide pg 44-45

Q3

Which one of the following is an important characteristic of an information security policy?

A. Identifies major functional areas of information.

B. Quantifies the effect of the loss of the information.

C. Requires the identification of information owners.

D. Lists applications that support the business function.

Answer: A

Explaination: Information security policies area high-level plans that describe the goals of the procedures. Policies are not guidelines or standards, nor are they procedures or controls. Policies describe security in general terms, not specifics. They provide the blueprints for an overall security program just as a specification defines your next product - Roberta Bragg CISSP Certification Training Guide (que) pg 206

What I want to do is that I want to transform my each question to structured data format (which you can see as follow) so that I can store them in database.

organized format

I want to use Python to complete this task and I am sort of know I need to use regular expression to deal with it but I just don't know how to do.

Can anyone help with this? Your help would be really appreciated! Thanks!