CSVpySTAT get calandar info column

 To get from a date column the calendar info from Year, week, day, mounth, etc. you cab use the Get Calendar Info Function under the TAB 'Modify date'.

Choose the datetime column. Additional the requested Calendar Info.

Push the Button 'Build Calendar Info Column'

There it is:

CSVpySTAT convert text column to datetime column

 To convert text column to timedate column choose the TAB ' Modify date'.

After choose the column press the Button '...' then you will see the first row entry.

With the dropdown 'Current Date Format' you can choose the current format.

You have the possibility to set a new column name.

After push the Button 'Build Date Column' there is a new Column with the ISO-Date Format of Python.

CSVpySTAT sort Column function

 To sort the columns to one column entries choose the TAB 'Format table' and use the 'Sort table by Column' function.

 

Choose the Column as root to sort.

Then set the sort direction and push the 'sort' Button.

CSVpySTAT set Filter function

 To set filter to column entries choose the TAB 'Format table' and the function 'Set filters'.

Choose the requested Column, push the Button '...' to get the filter possibilities.

Then choose the Content which is requested and push the button 'set new filter'.

 

CSVpySTAT Change Format function

 Into the TAB 'Format table' there you will find the function where it is possible to change the column format.

First choose the Column Name.

Click to the ... Button to see which is the current format.

After that choose the new wanted format and press the Button 'set new format'

CSVpySTAT Datatable is based on the Python Project tksheet

 Into the Tool CSVpySTAT the Datatable is based on the Project tksheet and there functions. You can use them after go to the TAB 'Datatable'.

Into this table you have the edit-functions:

- Cut contens

- Copy Contens

- Paste

- Clear Contens

- Delete Column

- Insert Columns

- Delete Rows

- Insert Rows

- Cut, Copy, Paste and Delete into a cell.

 

 

 

CSVpySTAT HowTo create a new Dataframe

 With CSVpySTAT it is also possible to create a new dataframe.

Therefore use the TAB 'New DF'. Set the amount of columns and rows and press the Button 'create DF'.

After this step an empty Dataframe is created.

 Now it make sence to give the columns names. Therefore use under the TAB'New DF' the 'define CN' Function.

 

After setup the Columnname ist is possible to edit into the TAB 'Datatable' and safe the Dataframe with the TAB 'Save CSV'.