Mahmoud Bani Asadi Softwaretrain
Softwaretrain
/ Reconcile.py
Last active
September 8, 2023 19:50
Python Code for Bank Reconciliation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import pandas as pd | |
| # خواندن فایل‌های ورودی | |
| bank = pd.read_excel(r"D:\Personal\Python\Reconcile\bank.xlsx") | |
| dafater = pd.read_excel(r"D:\Personal\Python\Reconcile\dafater.xlsx") | |
| # ایجاد ستون جدید با ترکیب مبلغ و تاریخ و شماره گذاری در صورت تکراری بودن | |
| bank['ترکیب'] = bank['مبلغ'].astype(str) + '-' + bank['تاریخ'].astype(str) + '-' + bank.groupby(['مبلغ', 'تاریخ']).cumcount().add(1).astype(str) | |
| dafater['ترکیب'] = dafater['مبلغ'].astype(str) + '-' + dafater['تاریخ'].astype(str) + '-' + dafater.groupby(['مبلغ', 'تاریخ']).cumcount().add(1).astype(str) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # خواندن جداول ورودی | |
| bank = xl("Bank[#All]", headers=True) | |
| dafater = xl("Dafater[#All]", headers=True) | |
| # ایجاد ستون جدید با ترکیب مبلغ و تاریخ و شماره گذاری در صورت تکراری بودن | |
| bank['ترکیب'] = bank['مبلغ'].astype(str) + '-' + bank['تاریخ'].astype(str) + '-' + bank.groupby(['مبلغ', 'تاریخ']).cumcount().add(1).astype(str) | |
| dafater['ترکیب'] = dafater['مبلغ'].astype(str) + '-' + dafater['تاریخ'].astype(str) + '-' + dafater.groupby(['مبلغ', 'تاریخ']).cumcount().add(1).astype(str) | |
| # مقایسه دو فایل بر اساس ستون ترکیب | |
| result_bank = bank[~bank['ترکیب'].isin(dafater['ترکیب'])] |
Softwaretrain
/ GoogleSheetFunctions
Created
May 15, 2023 07:59
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //SplitAmount | |
| =ArrayFormula(LET( | |
| z,division, | |
| count,ROUNDUP(amount/z,), | |
| a,SCAN(0,count,LAMBDA(x,y,x+y))-count+1, | |
| b,SEQUENCE(SUM(count)), | |
| c,SCAN(0,b,LAMBDA(g,h,XLOOKUP(h,a,array,g))), | |
| e,BYROW(amount,LAMBDA(x,LET(n,z,a,MOD(x,n),b,REPT(n&"-",x/n)&IF(a,a,""),b))), | |
| f,TEXTJOIN(",",,e), | |
| g,TOCOL( ArrayFormula(split(transpose(SPLIT(f,",")),"-")),1), |
Softwaretrain
/ PqUISolution.txt
Last active
December 5, 2022 18:40
Solution to Excel BI Excel/Power Query Challenge 79 on LinkedIn
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let | |
| Source = Table.FromRows( | |
| Json.Document( | |
| Binary.Decompress( | |
| Binary.FromText( | |
| "JYzBCsIwEAX/JWcLL5um2T1qiSC0lqYRkdBTTUHwA/x8Zb3NzGFKMfFjydV36zuzHooZRRY+Z4jajcXxUTHVpw9+RAdcNZBrT5dhsKTGAnb/xbTvr60qLsAsPbkISRrmewwpIzzULDdTnxsC/SbrFw==", | |
| BinaryEncoding.Base64 | |
| ), | |
| Compression.Deflate | |
| ) |
Softwaretrain
/ Excel BI Power Query Challenge 9
Created
September 17, 2022 17:39
Link of the challenge: https://www.linkedin.com/posts/excelbi_powerbi-powerquery-dax-activity-6976750557134774272-6Hyy?utm_source=share&utm_medium=member_desktop
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let | |
| Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("LcxBCoMwEIXhqzyyFgnd9ADdeIc0izGmphA6YWZEvL1Run3fzwvBJbIBC6/YM4mikOHDAqoVndTFITgrGXPn9+b946lolQ7F/rWCJJzuZspocpDCGFe/8jLe8CIjNeHWR/79T+MJ", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Original Text" = _t]), | |
| ReplaceText=Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSk4sUdJRcgaSsTrRSiUZqUBeCJAE8ZJSE4uAXCcQBeInF+UngxQDqfyUzJzUYrBoen4KUNAdSIJ4BUWVicVAfkFRYiVQPhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [From = _t, To = _t]), | |
| #"Added Custom" = Table.AddColumn(Source, "Final Text", each let | |
| Translation = List.Buffer( | |
| List.Zip( | |
| Table.ToColumns(ReplaceText) |
Softwaretrain
/ gist:5d6dabbc67e4fe9ca459580b45818188
Created
September 12, 2022 06:14
Solution to Excel BI Excel/Power Query Challenge 19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let | |
| Source=Excel.CurrentWorkbook(){[Name="Table1"]}[Content], | |
| CustomColumn = Table.AddColumn(Source, "Answer", each let | |
| Spl=Text.Split([Sentence]," "), | |
| lenSpl=List.Transform(Spl,each Text.Length(_)), | |
| addlen=List.Zip({Spl,lenSpl}), | |
| tbl=#table({"Sentence","length"},addlen), | |
| filter=Table.SelectRows(tbl, | |
| let max = List.Max(tbl[length]) | |
| in each |
Softwaretrain
/ gist:c5e59aafb1862a217852cc742d18d40e
Last active
August 12, 2025 07:10
Mahmoud Lambda Functions
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| FUNCTION NAME: ABH | |
| VERSION:1.0 | |
| AUTHOR: Mahmoud Bani Asadi | |
| WEB: www.arshad-hesabdar.ir | |
| INSTAGRAM: @SoftwareTrain | |
| DESCRIPTION: | |
| This function converts a numeric value (integer or decimal) into its full Persian text representation. | |
| It handles negative numbers by prefixing "منفی"، separates the integer part into named segments | |
| (تریلیارد، میلیارد، میلیون، هزار)، and converts the fractional part into fractional units |