How to create CSV's from data frame row values in python? [duplicate]

Question

I have a data frame that has a row type that has A,B,C in repeated ways and they belong to different values an example below

Type Value Volume brand 
A     1     5      E
B     2     1      $
C     3     1      5 
C     2     1      2  
C     4     5      7 
B     2     1      E
A     3     3      $

The outcome I am searching for is to produce a CSV for A B and C

A.csv =

Type Value Volume Brand
A     1      5      E
A     3      3      $

B.csv =

Type Value Volume Brand
 B     2      1      $
 B     2      1      E

C.csv =

Type Value Volume Brand
 C     3     1      5 
 C     2     1      2  
 C     4     5      7

I know how to do this individually but I would like to learn a way to do this for all of them together like with a for because I have a data frame with 32 different types and doing them individually is not cost effficient so any help would be very valuable.

pandas.pydata.org/pandas-docs/stable/user_guide/groupby.html — wwii
– wwii, Commented Jan 26, 2020 at 4:56

M_S_N · Accepted Answer · 2020-01-26 05:19:11Z

2

you can try this:

week_grouped = df.groupby('Type')

for name, group in week_grouped:
    print(name) # to get names of your group in this case A, B , C
    group.to_csv(f'{name}.csv')

check using

df_A=pd.read_csv('A.csv', index_col=0)

answered Jan 26, 2020 at 5:19

M_S_N

2,8061 gold badge19 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create CSV's from data frame row values in python? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related