5 𝐦𝐨𝐬𝐭 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐏𝐲𝐭𝐡𝐨𝐧 𝐥𝐢𝐛𝐫𝐚𝐫𝐢𝐞𝐬 𝐟𝐨𝐫 #𝐚𝐜𝐭𝐮𝐚𝐫𝐢𝐞𝐬 𝐭𝐨 𝐮𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐩𝐨𝐰𝐞𝐫 𝐨𝐟 𝐢𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐧𝐠 𝐞𝐱𝐜𝐞𝐥 ?

-

 5 𝐦𝐨𝐬𝐭 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐏𝐲𝐭𝐡𝐨𝐧 𝐥𝐢𝐛𝐫𝐚𝐫𝐢𝐞𝐬 𝐟𝐨𝐫 #𝐚𝐜𝐭𝐮𝐚𝐫𝐢𝐞𝐬 𝐭𝐨 𝐮𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐩𝐨𝐰𝐞𝐫 𝐨𝐟 𝐢𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐧𝐠 𝐞𝐱𝐜𝐞𝐥


#xlwings - it is easy to call Python from Excel and vice versa

#pandas - pandas has rich tools for reading and writing Excel and
CSV files.

#XlsxWriter - a Python module for writing files in the Excel 2007+ xlsx file format

#openpyxl - openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.

#vb2py - vb2py is a toolkit to aid in the conversion of Visual Basic projects to Python.

𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐦𝐲 𝐘𝐨𝐮𝐓𝐮𝐛𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐏𝐲𝐭𝐡𝐨𝐧 𝐚𝐧𝐝 𝐒𝐐𝐋 𝐟𝐨𝐫 𝐀𝐜𝐭𝐮𝐚𝐫𝐢𝐞𝐬

YouTube - Actuary Sense

Follow me on Linkedin: Kamal Sardana

Comments

Post a Comment

Popular posts from this blog

Do you know the difference between Excess and Deductibles ?

-
Image
Excess vs Deductibles: Let's have a look at little bit of background The main motive behind both of these is to safeguard the insurance company from frequent or frivolous claims. People after purchasing the insurance policy become careless because they know that in case of any incident they will be paid off from the insurance company so to avoid this excess or deductible are used. Now,the main difference are as follows: An excess is an amount a policyholder must bear before the liability passes to the insurer (subject to the sum insured) Deductible is an amount withheld by the insurer from the claim amount paid to the policyholder. Let's see 2 examples to understand in an easy way. Scenario 1 A policy has a sum assured of $1000 and an excess of $100 Now if the loss to insured is $500, then insurer will pay 500 -100 = $400 If loss to the insured is $1500, then insurer will pay $1000 (as it is the max amount that insurer can pay) Scenario 2 A policy has a sum assured of $1000 and
Read more

IFRS 17 - Actuarial Science - Part 1

-
Image
IFRS 17 Insurance Contracts is a new accounting standard that entities are expected to apply for reporting periods beginning on or after 1 January 2023 (though earlier application is permitted). An accounting standard is a common set of principles, standards, and procedures that define the basis of financial accounting policies and practices. It supersedes IFRS 4 Insurance Contracts as it was an interim standard for Insurance Contracts and lacked comparability, transparency, usefulness and qualify of information for insurers and key stakeholders. IFRS17 aims to increase the usefulness, comparability, transparency and quality of insurers financial statements. CSM (Contractual Service Margin) A fundamental concept introduced by IFRS 17 is the contractual service margin (CSM) . The CSM , in most instances, represents the unearned profit that an entity expects to earn as it provides services. IFRS17 is a principles-based standard, so entities must apply significant judgement when determ
Read more

Do you know about every Probability Distribution function with cool examples?

-
Image
  Probability Distributions:  It is a mathematical formula which helps us to find out the chances of occurring of an event. If we say that our dataset belongs to some particular distribution then we can say that probability of events in such dataset behave in a particular pattern. Say, the dataset is from uniform distribution then each and every event of range will have equal chances of occurring.   Types of distributions: Discrete Distributions:  Distributions defined for discrete random variables (which can take countable values such as 0,1,2,3….) are known as discrete distributions. Following given distributions are discrete: Uniform Distribution:  Data is said to be uniformly distributed if the probability of events is equal.                                               For example : Events in throw of a dice or flipping a coin have equal probabilities.   The number of bouquets sold daily at a flower shop is uniformly distributed with a maximum of 40 and a minimum of 3
Read more