stdout

JournalCode	JournalLib	EcritureNum	EcritureDate	CompteNum	CompteLib	CompAuxNum	CompAuxLib	PieceRef	PieceDate	EcritureLib	Debit	Credit	EcritureLet	DateLet	ValidDate	Montantdevise	Idevise

BCFA	BRED CFA	BCFA_juil.23_1	20230710	661600	Interets bancaires operations finan			1	20230710	INTERET 30-06-2023	18,51	0,00			20240704		

BCFA	BRED CFA	BCFA_juil.23_1	20230710	512502	BRED CFA			1	20230710	INTERET 30-06-2023	0,00	18,51			20240704		

BCFA	BRED CFA	BCFA_juil.23_2	20230710	411120	Clients FPC	C10026	CONSTRUCTYS_App	2	20230710	Virt reçu CONSTRUCTYS	0,00	3908,00	A		20240704		

BCFA	BRED CFA	BCFA_juil.23_2	20230710	512502	BRED CFA			2	20230710	Virt reçu CONSTRUCTYS	3908,00	0,00			20240704		

OD CHE	OD CHEVAUCHEMENT	OD CHE_juil.23_1	20230701	408100	FRS - FACT NON PARVENUES			1	20230701	COFODIS	20,40	0,00	A		20240704		

OD CHE	OD CHEVAUCHEMENT	OD CHE_juil.23_1	20230701	401120	FOURNISSEURS	F808908	COFODIS	1	20230701	COFODIS	0,00	20,40	HS		20240704		

OD CHE	OD CHEVAUCHEMENT	OD CHE_juil.23_2	20230701	408100	FRS - FACT NON PARVENUES			2	20230701	G GRONDIN	245,00	0,00	A		20240704		

OD CHE	OD CHEVAUCHEMENT	OD CHE_juil.23_2	20230701	401120	FOURNISSEURS	F808791	H-GRONDIN Guillaume	2	20230701	H-GRONDIN Guillaume	0,00	245,00	HT		20240704		

OD CHE	OD CHEVAUCHEMENT	OD CHE_juil.23_3	20230701	408100	FRS - FACT NON PARVENUES			3	20230701	COTTEREAU	525,00	0,00	A		20240704		



<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>JournalCode</th>
      <th>JournalLib</th>
      <th>EcritureNum</th>
      <th>EcritureDate</th>
      <th>CompteNum</th>
      <th>CompteLib</th>
      <th>CompAuxNum</th>
      <th>CompAuxLib</th>
      <th>PieceRef</th>
      <th>PieceDate</th>
      <th>EcritureLib</th>
      <th>Debit</th>
      <th>Credit</th>
      <th>EcritureLet</th>
      <th>DateLet</th>
      <th>ValidDate</th>
      <th>Montantdevise</th>
      <th>Idevise</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>BCFA</td>
      <td>BRED CFA</td>
      <td>BCFA_juil.23_1</td>
      <td>20230710</td>
      <td>661600</td>
      <td>Interets bancaires operations finan</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>1</td>
      <td>20230710</td>
      <td>INTERET 30-06-2023</td>
      <td>18,51</td>
      <td>0,00</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>20240704</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>1</th>
      <td>BCFA</td>
      <td>BRED CFA</td>
      <td>BCFA_juil.23_1</td>
      <td>20230710</td>
      <td>512502</td>
      <td>BRED CFA</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>1</td>
      <td>20230710</td>
      <td>INTERET 30-06-2023</td>
      <td>0,00</td>
      <td>18,51</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>20240704</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>2</th>
      <td>BCFA</td>
      <td>BRED CFA</td>
      <td>BCFA_juil.23_2</td>
      <td>20230710</td>
      <td>411120</td>
      <td>Clients FPC</td>
      <td>C10026</td>
      <td>CONSTRUCTYS_App</td>
      <td>2</td>
      <td>20230710</td>
      <td>Virt reçu CONSTRUCTYS</td>
      <td>0,00</td>
      <td>3908,00</td>
      <td>A</td>
      <td>NaN</td>
      <td>20240704</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>3</th>
      <td>BCFA</td>
      <td>BRED CFA</td>
      <td>BCFA_juil.23_2</td>
      <td>20230710</td>
      <td>512502</td>
      <td>BRED CFA</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>2</td>
      <td>20230710</td>
      <td>Virt reçu CONSTRUCTYS</td>
      <td>3908,00</td>
      <td>0,00</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>20240704</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>4</th>
      <td>OD CHE</td>
      <td>OD CHEVAUCHEMENT</td>
      <td>OD CHE_juil.23_1</td>
      <td>20230701</td>
      <td>408100</td>
      <td>FRS - FACT NON PARVENUES</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>1</td>
      <td>20230701</td>
      <td>COFODIS</td>
      <td>20,40</td>
      <td>0,00</td>
      <td>A</td>
      <td>NaN</td>
      <td>20240704</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
  </tbody>
</table>
</div>

  JournalCode        JournalLib       EcritureNum  EcritureDate  CompteNum  \
0        BCFA          BRED CFA    BCFA_juil.23_1      20230710     661600   
1        BCFA          BRED CFA    BCFA_juil.23_1      20230710     512502   
2        BCFA          BRED CFA    BCFA_juil.23_2      20230710     411120   
3        BCFA          BRED CFA    BCFA_juil.23_2      20230710     512502   
4      OD CHE  OD CHEVAUCHEMENT  OD CHE_juil.23_1      20230701     408100   

                             CompteLib CompAuxNum       CompAuxLib PieceRef  \
0  Interets bancaires operations finan        NaN              NaN        1   
1                             BRED CFA        NaN              NaN        1   
2                          Clients FPC     C10026  CONSTRUCTYS_App        2   
3                             BRED CFA        NaN              NaN        2   
4             FRS - FACT NON PARVENUES        NaN              NaN        1   

   PieceDate            EcritureLib    Debit   Credit EcritureLet  DateLet  \
0   20230710     INTERET 30-06-2023    18,51     0,00         NaN      NaN   
1   20230710     INTERET 30-06-2023     0,00    18,51         NaN      NaN   
2   20230710  Virt reçu CONSTRUCTYS     0,00  3908,00           A      NaN   
3   20230710  Virt reçu CONSTRUCTYS  3908,00     0,00         NaN      NaN   
4   20230701                COFODIS    20,40     0,00           A      NaN   

   ValidDate Montantdevise Idevise  
0   20240704           NaN     NaN  
1   20240704           NaN     NaN  
2   20240704           NaN     NaN  
3   20240704           NaN     NaN  
4   20240704           NaN     NaN  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>JournalCode</th>
      <th>JournalLib</th>
      <th>EcritureNum</th>
      <th>EcritureDate</th>
      <th>CompteNum</th>
      <th>CompteLib</th>
      <th>CompAuxNum</th>
      <th>CompAuxLib</th>
      <th>PieceRef</th>
      <th>PieceDate</th>
      <th>EcritureLib</th>
      <th>Debit</th>
      <th>Credit</th>
      <th>EcritureLet</th>
      <th>DateLet</th>
      <th>ValidDate</th>
      <th>Montantdevise</th>
      <th>Idevise</th>
    </tr>
  </thead>
  <tbody>
  </tbody>
</table>
</div>

Empty DataFrame
Columns: [JournalCode, JournalLib, EcritureNum, EcritureDate, CompteNum, CompteLib, CompAuxNum, CompAuxLib, PieceRef, PieceDate, EcritureLib, Debit, Credit, EcritureLet, DateLet, ValidDate, Montantdevise, Idevise]
Index: []

Analysis of Financial Transactions Trends Over Time

Are there any trends in the data?

Are you able to analysis all Revenue accounts ?

all accounts starting with 70 are sales accounts

JournalCode	JournalLib	EcritureNum	EcritureDate	CompteNum	CompteLib	CompAuxNum	CompAuxLib	PieceRef	PieceDate	EcritureLib	Debit	Credit	EcritureLet	DateLet	ValidDate	Montantdevise	Idevise
BCFA	BRED CFA	BCFA_juil.23_1	20230710	661600	Interets bancaires operations finan	NaN	NaN	1	20230710	INTERET 30-06-2023	18,51	0,00	NaN	NaN	20240704	NaN	NaN
BCFA	BRED CFA	BCFA_juil.23_1	20230710	512502	BRED CFA	NaN	NaN	1	20230710	INTERET 30-06-2023	0,00	18,51	NaN	NaN	20240704	NaN	NaN
BCFA	BRED CFA	BCFA_juil.23_2	20230710	411120	Clients FPC	C10026	CONSTRUCTYS_App	2	20230710	Virt reçu CONSTRUCTYS	0,00	3908,00	A	NaN	20240704	NaN	NaN
BCFA	BRED CFA	BCFA_juil.23_2	20230710	512502	BRED CFA	NaN	NaN	2	20230710	Virt reçu CONSTRUCTYS	3908,00	0,00	NaN	NaN	20240704	NaN	NaN
OD CHE	OD CHEVAUCHEMENT	OD CHE_juil.23_1	20230701	408100	FRS - FACT NON PARVENUES	NaN	NaN	1	20230701	COFODIS	20,40	0,00	A	NaN	20240704	NaN	NaN