fork(1) download
copy 
  1. # your code goes here
  2. import pandas as pd
  3.  
  4. data = """Equipe	outrodado
  5. NomeEquipe1	---
  6. NomeEquipe2	---
  7. NomeEquipe1	---
  8. NomeEquipe2	---
  9. NomeEquipe	---"""
  10.  
  11. data = [ x.split('\t') for x in data.split('\n') ]
  12.  
  13. df = pd.DataFrame(data[1:], columns= data[0])
  14.  
  15. df = df['Equipe'].value_counts()\
  16. 		.reset_index()\
  17. 		.rename({'index':'MinhaColuna'},axis=1)
  18.  
  19. print( type(df) )
  20. print( df.columns )
  21. print( df )
Success #stdin #stdout 0.47s 60700KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
<class 'pandas.core.frame.DataFrame'>
Index(['MinhaColuna', 'Equipe'], dtype='object')
   MinhaColuna  Equipe
0  NomeEquipe1       2
1  NomeEquipe2       2
2   NomeEquipe       1
https://ideone.com/M5IgB1
language:
Python 3 (python  3.9.5)
created:
2 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!