In python how to extract the common repeated values Company Name base particular column getting the relevant rows data features parameters

0 votes

1. I have a folder with multiple csv files stores. i am trying to fetch the common companies and parameters based on the year Column, and based on the Risk Return column.
1. The condition for Risk return >0 followed-by company name is it there in all the 10 years if the 2 conditions are satisfied then it has to save in separate file.

Sample Data view:
Like this i have data csv files for 10 years

Company Name Total Reserves/Total Assets Total Reserves/Total Current Liabilities Total Reserves/Net Assets Closing Cash & Cash Equivalent Growth Year Risk Adjusted Return
Archies Ltd. 0.609629 3.420958 0.922252 -13.2027 2009-10 6.963131
Shoppers Stop Ltd. 0.279474 0.751713 0.860496 -53.3125 2009-10 5.017301
Bata India Ltd. 0.405643 0.828716 0.910929 101.2264 2009-10 3.676464
Vaibhav Global Ltd. 0.252348 2.246791 0.775817 96.97768 2009-10 0.718685
Trent Ltd. 0.480978 1.881055 0.965781 239.456 2009-10 0.075448

 1. Like this there are 10 csv files im trying to extract the common company names based on the number of years it has repeated in 10 years, randomly and continuously more than 5 years.

import pandas as pd
import glob

path = r'C:/Users/harik/Success company' # use your path

all_files = glob.glob(path + "/*.csv")

li = []

for filename in all_files:

    df = pd.read_csv(filename, index_col=None, header=0)


frame = pd.concat(li, axis=0, ignore_index=True)


frame.drop(['Unnamed: 0'], axis=1)

pd.value_counts(frame['Company Name'].values)

Output: company names that are common in 10 yearly wise csv files 
> Trent Ltd.                    8  
Vaibhav Global Ltd.           8  
Bata India Ltd.               6  
Archies Ltd.                  6  
V-Mart Retail Ltd.            6  
V2 Retail Ltd.                6  
SORIL Infra Resources Ltd.    5  
Shoppers Stop Ltd.            5  
Future Enterprises Ltd.       4  
Avenue Supermarts Ltd.        2  
Future Retail Ltd.            2  
SRS Ltd.                      2  
Brandhouse Retails Ltd.       1  
Olympia Industries Ltd.       1  
eDynamics Solutions Ltd.      1  
dtype: int64  

 - But i want the out with along with its relevant feature in the dataset.
 - I Did this, Now how to write the condition for this all the data.

1. Consider only those companies whose risk adjusted return >0

2. Should not consider all the companies across industries for any comparison. Comparison should be within industry

3. Should remove the inconsistent companies for finding the commonalities

4. Yes you should have at least 4-5  Years to retrieve the commonalities. Look into the industries across 117 to find the consistency between companies. Those industries didn't have the consistency for the companies let's make a list.

How this can be applied, could some one help me how this points are applied in the form of code.


Nov 25, 2020 in Python by anonymous
• 160 points

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Python

0 votes
0 answers

how to merge two data frames based on particular column in pandas python?

I want to  merge two data frames: df1 company,standard tata,A1 cts,A2 dell,A3 df2 company,return tata,71 dell,78 cts,27 hcl,23 I ...READ MORE

May 26, 2022 in Python by Kichu
• 19,050 points
0 votes
1 answer

How to replace values with None in Pandas data frame in Python?

Actually in later versions of pandas this ...READ MORE

answered Aug 30, 2018 in Python by Priyaj
• 58,090 points
0 votes
1 answer

How can I change the data type to string in Python?

You can use str(variablename) This is called conversion ...READ MORE

answered Dec 18, 2018 in Python by Shuvodip
0 votes
1 answer

How to output the rows which are affected using SQLAlchemy in Python?

Hi, good question. This is actually not ...READ MORE

answered Feb 15, 2019 in Python by Nymeria
• 3,560 points
0 votes
1 answer

How to get the ASCII values of a character in python?

You can get the ASCII value of ...READ MORE

answered Aug 23, 2020 in Python by Sajetha Selva
–1 vote
2 answers
0 votes
1 answer

Python: Issue with 'unexpected end of pattern'

I should start by stating that using ...READ MORE

answered Sep 12, 2018 in Python by Priyaj
• 58,090 points
0 votes
1 answer

How to create Pandas series from numpy array?

Hi. Refer to the below command: import pandas ...READ MORE

answered Apr 1, 2019 in Python by Pavan
0 votes
1 answer
0 votes
1 answer

How to create Pandas series from dictionary?

Here's a sample script: import pandas as pd import ...READ MORE

answered Apr 1, 2019 in Python by Prateek
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP