Counting Values in Python Sequence with Counter

How many NaNs in a #Python #Pandas series? Use isna (returns True/False) then sum/value_counts: s = pd.Series([10, 20, np.nan, 40, 50, np.nan, 70, 80]) s.isna().sum() # returns 2 s.isna().value_counts() # count True/False Hint: Pass normalize=True for the percentage

Want to guarantee that no one can run "from .. import *" on your #Python module? Include a non-existent name in the __all__ list: x = 100 y = [10, 20, 30] __all__ = ['YOU_SHOULD_NOT_USE_IMPORT_*'] Using "from .. import *" on this module will result in an error!

🚀 The 'in' Operator: Checking Membership in Data Structures (Python) The 'in' operator is used to check if a value exists within a data structure like a list, tuple, set, or dictionary. For lists and tuples, it checks if the value is present as an element. For sets, it provides efficient membership testing due to their underlying hash table implementation. For dictionaries, it checks if the value is present as a key. #Python #PythonDev #DataScience #WebDev #professional #career #development

Load custom #Python modules into #Excel 🤯 The *real* Python in Excel i.e., #xlwings Lite (https://lnkd.in/eMuEm773), just got better! Felix Zumstein recently announced the new feature in xlwings Lite to drag and drop data files straight into Excel (https://lnkd.in/ePVR9jUd), that was exciting! Now you can mount your own personal #Python modules into #Excel! See here (https://lnkd.in/epPcXYPw) how to do it. This is proof that you can import your own custom Python modules into Excel. Really exciting! 🤩

I haven't properly announced this feature yet, but yes, you can now import or mount local Python files that automatically register as scripts in your Run button or as custom functions across all workbooks (and you can import them into main.py). It works like the venerable "Personal.xlsb" file with VBA. It's a little smarter though, as you can filter modules to only load with certain workbooks. E.g., whenever I open a Stripe report, my cleanup_stripe script automatically appears. Since these files are on your local machine, you can track them with Git or store them on OneDrive, etc. See https://lnkd.in/e_CU9tmP #pythoninexcel #python #microsoftexcel

As far as i know, xlwings from Felix Zumstein is still the Best way to use Python in Excel sheets. It's been a while Microsoft said Python will be embedded in Excel... but where is it ?

Python Challenge What will be the output of this code? x = [1, 2, 3] y = x y.append(4) print(x) A) [1,2,3] B) [1,2,3,4] C) Error D) None Drop your answer before checking the comments 👇

Apply different aggregations to each column when grouping on a #Python #Pandas data frame with agg and a dict: ( df .groupby('VendorID') [['trip_distance', 'total_amount']] .agg({'trip_distance':['median', 'std'], 'total_amount':'mean'}) )

Unsure how many values you want to unpack in #Python? Use * to get a list of flexible length: x = [10, 20, 30, 40, 50] a,b,c = x # error! a,b,*c = x # c is [30, 40, 50] a,*b,c = x # b is [20, 30, 40] *a,b,c = x # a is [10, 20, 30] Note: You can only have one * variable.