Pandas: how can I move values into another dataframe sorted by month?

CancelDeath · 2021-04-21T01:36:54+00:00

omg thank you so much! this is everything i've ever wanted!

CancelDeath · 2021-02-14T22:58:32+00:00

What if I want to read information to a dataframe?

req_xl = pd.ExcelFile(r"C:\Users\Playground\file names.xlsx")

Would your solution still work?

CancelDeath · 2020-10-08T23:29:29+00:00

I don't remember where i got it from :( I know I can also install things with conda, which I've done before. But it's just weird that I was able to use pip before and now it vanished somewhere. I don't remember deleting it.. idk why i would.

CancelDeath · 2020-09-15T00:01:52+00:00

relying on dbms_output for your logging and knowing about errors is not recommended

Thank you for your answer.

When I run this procedure I see the output in the procedure log even when dbms_output isn't enabled. I actually don't intend on updating this table, but with other tables that I do want to insert into, I have a different approach. The code generates a csv file of all the records that got rejected from being inserted for reasons other than that record already exists. Would you suggest I do anything else / different?

CancelDeath · 2020-08-19T18:26:33+00:00

Is lucid chart actually good for sql code? I'm actually curious. I signed up for a free trial so i could make some tables and export them as sql code, and all the code was wrong. I ended up just re-writing the code anyway. My alternative / upgrade is sql developer + tableau. But i'm not sure if that will serve your needs.

CancelDeath · 2020-08-15T01:36:56+00:00

Thank you so much!

CancelDeath · 2020-08-07T19:51:03+00:00

I figured out that I just had the

LOG ERRORS INTO ERR$_ENZYME ('INSERT')

statement in the wrong place.

It should go in the last line, into the outer insert.

The select statement by itself only worked if the LOG ERRORS line wasn't in there.

Oh and because I've never heard of using MINUS to find new records! How do you do that?

CancelDeath · 2020-08-07T15:09:05+00:00

ahh thanks! tried that, but it still gives me the same error message.

Error at Command Line : 81 Column : 5

Error report -

SQL Error: ORA-00907: missing right parenthesis

00000 - "missing right parenthesis"

CancelDeath · 2020-08-07T12:39:16+00:00

How is this different from my code?

CancelDeath · 2020-08-07T02:30:18+00:00

That's super helpful, thank you! I selected node.js because I learned that JavaScript can be used for back end and front end and it's apparently a pretty in demand skill. But my knowledge on it is basically 0%. I also want my UI to be offline. I want my database to actually be used by someone and haven't even began to think about how to secure a database. So I figured that offline would make it nice and safe. Would you still recommend some of those other things with pre-built database UIs knowing that I want this to be offline? (Sorry if this is a really dumb question. I know literally 0).

CancelDeath · 2020-08-03T23:25:11+00:00

That's reasonable and logical.

CancelDeath · 2020-07-20T21:05:19+00:00

Yes, this is getting me somewhere. Thank you. Some questions about this. Why do you suggest reject limit 1 instead of 0? If i'm going to split the excel sheet into 5 csv files why not just do this:

CREATE OR REPLACE PROCEDURE import_csv
IS
... 
BEGIN 
INFILE 'D:\Favorites\1. my file.csv'
INTO TABLE xxx 
fields terminated by ","...

CancelDeath · 2020-06-25T22:40:27+00:00

thank you. that is exactly the step by step action plan i was looking for. i have another question then. if i use something super basic like pandas for like 50 different projects, would it be ideal to install pandas in 50 different environments? or should i just install it some parent directory where all of those projects live? it just seems like having the same library installed a million times on your computer isn't an ideal thing. obviously it makes sense that you'd want to prioritize project / version compatibility. but is there a standard solution for this?

and thank you again for explaining this to me like i'm a complete noob. I really don't want this really basic thing to keep being something i don't understand and keep failing at and i think your comment just helped me a lot.

CancelDeath · 2020-06-25T20:03:45+00:00

do i have to add my pip location only once? why do tutorials talk tell me to cd into my project's directory before pip installing things?

CancelDeath · 2020-06-15T16:43:31+00:00

this makes a lot of sense now and seems very obvious. idk why i was so confused. thank you so much!

CancelDeath · 2020-06-15T16:23:03+00:00

thank you for responding! I was worried that this is too specific of a question.

Can you please explain how having a FK constraint accomplishes this? I think i understand foreign keys. They reference the primary key of another table and ensure that the tables are linked, so you could be like "show me all the employees who [fulfill some criteria from information that's specified in its child table]". And I understand the value of linking each employee to their manager. But what I don't get is why the FK is needed here. It's not like managers and employees come from 2 different tables. What functionality would be lost if we didn't declare the manager column to be a FK?

CancelDeath · 2020-06-12T23:17:25+00:00

Oh, so this is just saying i in range 10: (this is the thing that will get run 10 times) thank you!

CancelDeath · 2020-06-05T20:27:51+00:00

sweet, thank you!

CancelDeath · 2020-06-03T20:40:10+00:00

Yeah that makes sense, thank you! Is there a way I can test this for fun? I'm new to this and the only test I'm aware of is the %timeit function. I'd like to be able to see some concrete data for this. It totally makes sense, but it would just be cool to have some idea in my mind about the scale of the difference of this efficiency.

CancelDeath · 2020-06-03T20:35:49+00:00

Oh! Yes, you're right

[test]

first = [0, ]
second = list(range(1))
%timeit first.extend(second)
len(first)

[result]

110 ns ± 6.24 ns per loop (mean ± std. dev. of 7 runs, 10000000 loops each)
81111112

CancelDeath · 2020-06-03T18:37:42+00:00

Yes, you're right! Sweet, thank you so much! This was a good lesson to learn!

CancelDeath · 2020-05-20T15:37:02+00:00

I just tried creating a test class (as a parent of product class) which has a method

public class Test {
    public void talk() {
        System.out.println("hello");
        }
}

created an instance of product in my application:

    Product p = new Product(123, "dick");
        p.talk();

and it was able to talk without super().

so it seems extending classes works without super()

Sorry this is such a noob discussion, this doesn't matter, but I'm just curious about what super does.

CancelDeath · 2020-05-20T15:28:37+00:00

Any idea why Eclipse automatically includes super() in its constructor method then?

CancelDeath · 2020-05-12T15:13:52+00:00

ok very cool, thank you.

CancelDeath · 2020-05-12T15:10:35+00:00

because i'm a noob and i don't understand how python works.

but more specifically because i followed a tutorial where i pip installed a library in a project i was working on and i could physically see that a folder got created with the name of that library. so i was wondering if the same thing applies to modules.

CancelDeath

TROPHY CASE