Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • thank you! @BlivetWidget, how do you sort it both by depth AND profile? each profile has a set of depths and each dataframe has a bunch of profiles? Commented Apr 12, 2019 at 18:30
  • 1
    @PEBKAC you can sort it by however many parameters you want, in whatever order you want. .sort_values(['depth', 'profile']) or .sort_values(['profile', 'depth']). You can check the help on df1.sort_values to learn how to change the sort order, to sort in place, and various other optional parameters. Commented Apr 12, 2019 at 18:43
  • @BlivetWidget, I'm sure this is a silly question, but I have 3 dataframes I need to join - does it matter if 1) they have no data in common and 2) their columns are not in the same order? By 1, I mean that they have the same columns, but each row contains different data (this is 3 different infection types). And, yes, I'm going to try it and see what happens. Commented Nov 19, 2021 at 14:45
  • 1
    @DataGirl that's not a problem, but as with anything else, only you can say if the result is what you wanted it to be. Saying "join" in English is not very specific. There are other functions like df.combine(), df.join(), and df.merge() that are worth looking into if df.append() doesn't do what you want. Commented Nov 23, 2021 at 13:04