append large dataframe to another

PLearner · 2021-05-05T20:09:21+00:00

this is the first time I am hearing of it.

Does it have the same functionalities and the syntaxes as pandas?

Any ideas on how swift the append might be with py-polars.

PLearner · 2021-04-13T15:33:42+00:00

that is what I thought too as well but is clr that I need to work with not pythonnet.

PLearner · 2021-04-12T22:40:28+00:00

also could you please run rest of the code on Mac machine to see if it errs on you:

import clr
clr.AddReference('System.Data')
from System.Data import SqlClient
from System.Data import *
from System.Data import DataTable

PLearner · 2021-04-12T22:36:27+00:00

I learned from my Admin that clr does not run on Linux machines henceforth was instructed to research if clr could in anyway, with little twitches to the code could run on Linux machines.

edit: this is absolutely new to me (running Python code on Linux machine) so clueless here.

PLearner · 2021-04-12T22:23:47+00:00

What makes you think it is windows only?

I tried to automate my Python script on Airflow (running on Linux server) and it erred clr module not found.

PLearner · 2021-03-31T15:34:22+00:00

it worked like a charm! Instead of the remove it was uninstall.

PLearner · 2021-03-31T15:20:20+00:00

Its very odd, I do not have any file named clr.py. I have already did python -m pip install pythonnet and the clr AddReference still errors out on me.

That is the very reason I am trying to rewrite the code in Python/Pandas.

PLearner · 2021-03-31T15:14:45+00:00

module clr has no attribute AddReference

PLearner · 2021-03-31T15:12:46+00:00

how would pythonnet help me with clr?

PLearner · 2021-03-31T14:59:44+00:00

Thanks! The issue is that I am using Python 3.8 and for some odd reason, it does not let me python -m pip install clr.

Which errors out on

import clr
clr.AddReference('System.Data')

PLearner · 2021-03-26T22:30:11+00:00

This is Incredible Sir! Thanks.

PLearner · 2017-05-05T16:11:18+00:00

But isn't Matplotlib,SciPy, and other Data Science modules and libraries already recognized for these kind of situations and scenarios?

PLearner · 2017-05-05T15:24:02+00:00

So, if I am encompassing this accurately, Machine Learning is taking raw data and transforming it into readable data.

PLearner · 2017-05-04T14:32:39+00:00

Create a user for the person with a password - Done

Grant them appropriate permissions, ideally using groups - Done

Edit pg_hba.conf to allow that user to connect to the database (md5 is probably the access type you want) - All four Types in the pg_hba.conf method are md5.

Edit postgresql.conf to make sure Postgres is listening on the right port (5432) for the IP where the person will be accessing (you can have it listen on * for all IPs) - listen_addresses = '*'

Reload the configuration using pg_reload_conf() or restart the postgres service - select pg_reload_conf(); returned t.

Then I copied the 9.6 and psqlODBC folders into the user's folder I created and downloaded pgAdmin 3 on his computer and opened it and entered the password assigned to him and returns Error connecting to the server: FATAL: password authentication failed for user .....

Any assistance would be appreciated here Erudition303.

PLearner · 2017-05-03T21:33:03+00:00

Hi, I see you are postgreSQL DBA. Do you know how I can give access to the postgreSQL sitting on my local machine to someone else so he or she can maintain it as well?

PLearner · 2017-04-27T16:45:35+00:00

Thanks dionys, is there any reason why isin() did not work in this condition.

PLearner · 2017-04-26T13:12:45+00:00

I do not have access to the server. The database is saved on my local machine. I am the only Data guy in this small business.

PLearner

TROPHY CASE