anky

anky has asked 6 questions and find answers to 309 problems.

Stats

About

I am a data engineer. I am here to upskill myself and help the community with whatever I learn. I am active on -> pandas, python and sometimes on pyspark tags.

Some of my favorite answers (WIP):

PySpark:

create a table with spark.catalog.createTable
How do I find the most frequent element in a list in pyspark?
How to Transpose multiple columns in a Dataframe
PySpark - Split Array Column into smaller chunks

anky questions

Change mixed data types in power query to decimal- Power BI
Pandas groupby transpose
Extract age from a string-python
Get fiscal year based on current timestamp-python
how to iterate through keys and values in a dictionary in python [duplicate]
Make first few rows unresponsive to slicer Power BI

anky answers

change multiindex level: "ValueError: On level 0, code max >= length of level"
Pandas subtracting rows gives wrong result
pandas str split and apply, create multiindex df
Pandas Concatenate/Merge Two Dataframes with Priority
How to filter in rows where any column is null in pyspark dataframe
Python Pandas: Create cumulative average while grouping by other column
Updating values for a subset of a subset of a pandas dataframe too slow for large data set
Pandas - combine two Series by all unique combinations
How do I merge two data frames if a column and it's values exist in both data frames?
Pandas DataFrame: Subtract columns with string datatype