2024-10-11, 11:30–12:00 (Europe/Luxembourg), Auditorium
This talk about Conditions (If, Sumif and Countif) in Python programming and LibreOffice. I will talk about If, countif and sumif applied in Python programming and in LibreOffice Calc. Theory of If, Sumif and Countif with 3 examples from easy to harder ones will be delivered using both of them.
There is If in both of them but Sumif and countif commands only available in LibreOffice Calc while Python programming will use other techniques to obtain same result with Countif and Sumif. In Python programming , data retrieved from Ods file, same with LibreOffice Calc. Pandas is used in Python programming to read the Ods file. Text editor used in Python programming is Pycharm.
This is the comparison of conditions between Python programming and LibreOffice Calc.
Akhmad Sofwan is a Lecturer and Researcher in Records and Archives management, Vocational Education Program, Universitas Indonesia. His research interests are Computer programming, Data Mining and Spatial Data Mining. He is also a Software Developer using Python, JavaScript and PHP.