![](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.
Can the channel owner delete comments on their videos?
p2p is also cheaper, bandwidth-wise, but packages are usually not that big to justify it.
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
Idk, trying to solve something on Linux is usually just running some command on the terminal and your done. In windows you have to edit some special file on the registry or something like that. I think it’s what you are used to use, I’m being a Linux user for 14 years now, I can’t even think of how to solve something in windows (windows XP was my last windows install)
I know, that message was for the people who was about to comment about how R-Studio is an IDE for R.
The one you know is called RStudio.
Pretty cool bug. Looks like a surreal meme
Or techno.
Philosophy Tube have a great video about Effective Altruism. It was some time ago that I watched, but iirc, EA is just “let us do unregulated capitalism at our own benefit, because in the future trillions and trillions of humans are going to benefit from it. Don’t mind the planet being destroyed now, and the billions of humans suffering now, everything would be cool in future. Trust me bro.”
I use lambda functions on my panda’s data frames when I need to do row operations, with .apply().
Any statistical analysis method -> AI
There’s a lot of universities using Linux on their pc labs, I guess you can look up how they admin their systems to compare. When I was in college, I had a programming class (R language for actuarial sciences) and the computer had some restrictions, like we couldn’t save anything locally so we had to plug a pendrive to save our scripts and we couldn’t install any library not installed by default.
How many audio notifications do you receive? The only ones I get are from the phone.
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.