In [1]:

    

import collections

from matplotlib import pyplot as plt
%matplotlib inline
import pandas as pd
pd.set_option('display.max_columns', 500)


    

In [2]:

    

filename = 'LBB_ETT_ETT_20160418_20170518_20170518_165325_sample.csv'


    

In [ ]:

    

df = pd.read_csv(filename, sep='|', encoding='utf-8', na_filter=False)


    

In [7]:

    

df[df.dc_romev3_1_id != 'NULL']


    

    
Out[7]:






  

    

      

      
siret_ett
      
siret_etu
      
dd_datedebutmission
      
dd_datefinmission
      
dn_nbjcaltotalmission
      
dn_nbjouvrestotalmission
      
dc_pcssimplifieesiett_trans_id
      
dc_nafinsee700_id
      
dn_nbmission
      
dc_nafrefv2_id
      
dc_lblpcsinsee
      
dc_cptdptrgnsiett_etu_id
      
dc_trancheeffectif_id
      
dc_romev3_1_id
      
dc_pcssimplifieesiett_decla_id
      
dc_cptdptrgnsiett_lieu2_id
    
  
  

  

In [8]:

    

column_names = [
 'dn_nbjcaltotalmission',
 'dc_nafinsee700_id',
 'dn_nbmission',
 'dc_nafrefv2_id',
 'dc_trancheeffectif_id',
 'dc_romev3_1_id',
 #'dc_romev3_2_id',
]


    

In [ ]:

    

df[column_names][::55]