![](https://lemmy.eco.br/pictrs/image/0fd624b1-4ba6-485a-b683-d308c93888f4.jpeg)
![](https://programming.dev/pictrs/image/1d99f7cb-50e7-4994-94c4-fd23f30209b7.png)
I have a Datawerehouse some of the dabases I got come from there, but can only be accessed in the virtual machine.
I have a Datawerehouse some of the dabases I got come from there, but can only be accessed in the virtual machine.
There’s some reports that need to be run monthly, they need to be edited each month to add the directories with the new databases and it causes problems, some of them im trying to solve with this. There’s also a lot of ad hoc statistics studies I need to do, that use the same bases.
Never heard of that, just saw a video and even if isn’t exactly what I need it’s looked really cool.
There’s some data that comes in CSV, other are database files, in the SQL server, excel or web apis. From some of them I need to combine multiple sources with different formags even.
I guess I could have a database with everything more tidy, easier to use, secure and with less failure ratio. I’m still going to prepare the databases (I’m thinking on dataframe objects on a pickle, but I want to experiment with parquetd) so they don’t have to be processed every time, but I wanted something I could just write the name of the database and get the update version.
Thanks, I could solve it creating a file with a def get_database(name):
if name == ‘database’:
all the process to create the database
return database
And then df = get_database(‘database’) execute all the processes and return it.
The details can be fixed but the general idea is good.
The last one is a cool concept, but pie charts are pretty useless lmao
The gray box kinda looks like an VR glasses
I was hoping for a sand clock and the python snake, but now I’m not sure if the sand clock is an international actuarial thing, or if is just a brazillian one. But for mathematical notation related to actuarial sciences the annuanity [1] is the main one, so 2/10.
Guess is the blue and yellow hexagons
*Acess granted to the homologation DB that haven’t been fully updated since 2018*
Some guy opened like 10 jira tickets asking a bunch of data that is already available for them on the BI. I show it how to extract it himself, and then marked all the other ones as duplicated and for a moment I felt myself as an stackoverflow mod.
Transphobes are not welcome, so it was in fact the right attitude.
Fucking hate when do that.
You are repeating the same mistake.
I’m sorry for repeating the same mistake, here’s a new solution with corrections *proceed to write the exactly thing already told it was wrong*
What did you asked ChatGPT? I tried it and straightforward said that the date field wasn’t included on the select statement
https://chatgpt.com/share/80918db9-5284-4a9b-b971-dde78b00497a
It’s in 1068-OSI format
And they would use at least a quarter or your RAM.
Top right corner: “the most recent 12 months are highlighted”
Yes, kinda.
They get updated by the accounting team each month. Some of them are csv, other come from an access database file, other from the sql server.
Some of the code need to be run each month with the updated databases, but there’s a lot of ad hoc statistical studies that my boss ask for that use the same databases.
I guess yes. And not, the accountants keep the same filenames but change the directory lmao.
Thanks, im checking it out.
import sys sys.path.append('my\\modules\\directory) import my_module
You’re right, I’m an actuarie. I wanted to do computer science instead of actuarial sciences, but I tough that it would be better getting an actuarial degree and then doing a masters on CS (still in planning, maybe 2026). I’m the only guy on the company who uses python and people here thinks I’m a genius because I have automated some boring things from excel.