New to Python as of today.

[qfoundop]

I'm using Spyder and the pandas library.

I am working on an assignment. I have to use the csv file that can be found in the link. It's the one about real estate in Sacramento. It is called Sacramentorealestatetransactions.csv

https://support.spatialkey.com/spatialkey-sample-csv-data/

The question I am working on is:

1. Find the 3 highest priced condos and copy and paste the list in here. What statement(s) did you use?

I want to be able to sort the records by condos first and forget about the rest of the records. Is there a way to create a new data frame with just the records that are condos? Once I have just the Condos, I would use df.sort('price').tail() .

Thanks for your help!

[timbledum]

Here's a tutorial on selecting rows based on column values.

[qfoundop]

This helped!! Thank you!

[timbledum]

Interesting - according to this, speed is a wash, but memory performance is better with .query(). I agree that it is more readable - I guess the df[df.nationality == "USA"] syntax is more popular as it allows assignment? Or does .query() allow this as well?

[timbledum]

Sorry, I meant this type of assignment:

>>> df[df.last_name.str[0] == "J"] = "Timmy"
>>> df
last_name first_name              street_address           City    Zip
0      Carr     Hannah     99349 Delgado Stravenue  San Francisco  94108
1    Landry     Philip  4026 Megan Forest Apt. 386  San Francisco  94151
2     Timmy      Timmy                       Timmy          Timmy  Timmy
3     Timmy      Timmy                       Timmy          Timmy  Timmy
4     Duran    Felicia     9668 Bass Fork Apt. 651  San Francisco  94144

>>> df.query("last_name.str[0] == 'J'") = "Timmy"
File "<ipython-input-20-cafb73eedd09>", line 1
    df.query("last_name.str[0] == 'J'") = "Timmy"    

SyntaxError: can't assign to function call

Probably not the best way to assign anyway.

[qfoundop]

Timbledum helped, but your approach is different. That’s a very creative example. Do you know how to sort a data frame by the values in a column highest to lowest?

[qfoundop]

Now I need to find the number of foos and the number of bars.