I’m working on an accounting program, and I want to be able to have a function or macro that adds new account values to my dataframe, or another form that works as a CSV, XLSX or Database. Accounts = Dict( # A Dictionary of all my accounts ## List of Accounts and Starting Balance # Chequing …

General_Ledger=DataFrame(Chequing=[0],Inputs=[0]) JE3=DataFrame( EntryDate=[$newdate,"","",""], Credited_Accounts=["", "Chequing","",""], Debited_Accounts=["","","Inputs",""], Credit=[0,100,0,0], Debit=[0,0,100,0]) General_Ledger=DataFrame(Chequing=[0,100],Inputs=[0,100…

macro transaction( journal_entry, newdate, newdebit, debit_amount, newcredit, credit_amount, new_memo) ex=quote if $credit_amount != $debit_amount "Error--Debit and Credit must match" else push!(spreadsheet,(defaultRow..., $newcredit=$credit_amount, …

Here’s a way to do it for what I understood of the task: using DataFrames # Initialize accounts data frame with one row accounts = DataFrame( Chequing_debit=[100], Chequing_credit=[0], Wages_debit=[0], Wages_credit=[100], Sales_debit=[0], Sales_credit=[0], Rent_debit=[0], Rent_cred…

OK, I you did a function, then used symbol. That should allow me to do a function

Yes with a symbol and a pair => you can generate a named tuple where the keys are computed. For example instead of (; a=1, b=2) you can write sym = :b (; a=1, sym => 2) By the way, to define the new row for the data frame you can also use a Dict instead of a named tuple (this way you can use strin…

function transaction!(date,journalentry, debit_account, debit_amount, credit_account, credit_amount) if debit_amount != credit_amount error("Debit ($debit_amount) and credit ($credit_amount) must match") end # Prepare row as named tuple, starting with zero values overwritten by …

The extra ) is in new_row = .... Just remove the last one.

And here’s a simpler way, in case it’s OK to have missing instead of 0 values for accounts that are not touched by a transaction: using DataFrames accounts = DataFrame() journal = DataFrame() function transaction!(date, debit_account, debit_amount, credit_account, credit_amount) if debit_amou…

I fixed that, but now it’s saying that I can’t have have Symbol(debit_account) as the name of a column Symbol(journalentry)=DataFrame(Date=[newddate], Symbol(debit_account)=[0], Symbol(credit_account)=[0], balance…

I think I have it fixed, but I can’t test it. How do I do push! if I have a DataFrame or DataFrames? function transaction(date,journalentry, debit_account, debit_amount, credit_account, credit_amount) if debit_amount != credit_amount error("Debit ($debit_amount) and credit ($credit_amo…

Use a String For a Variable name and convert Dictionaries to DataFrames

General Usage

brett_knoss June 1, 2021, 8:39pm 33

I created a new thread
Creating an Accounting Program in Julia, for Pluto

Topic		Replies	Views
Creating an Accounting Program in Julia, for Pluto Finance and Economics question , dataframes , function , pluto	75	3678	June 8, 2021
Add a row to a dataframe General Usage question , dataframes	8	1042	June 1, 2021
Dictionaries can't find keys General Usage question , dictionary , dictionaries	34	1098	October 10, 2021
Initializing a dataframe New to Julia	23	11348	March 15, 2020
[ANN-RFC] DFMacros.jl Package Announcements dataframes	30	2201	June 19, 2021

Use a String For a Variable name and convert Dictionaries to DataFrames

Related topics