Find Jobs
Hire Freelancers

Data Manipulation, Pandas and Distance Metrics

$10-35 USD

Completed
Posted over 7 years ago

$10-35 USD

Paid on delivery
Write the Python code to load the CSV file from spatialkey directly into a Pandas dataframe. • You may need to familiarize yourself with the IO Tools functions of Pandas. • Turn in the fragment of code that does this. § Compute the price per square foot for all properties. Add this data back into the dataframe. • See the documentation on concatening objects. • Turn in the code that does this, and show the results of head() and tail() on the new dataframe. § Provide three data points from the original dataset that give your reason to be concerned about the some of the properties with unusual price per square foot data. • Learn about summarizing your data and sorting. • Turn in the rows of those three data points and 1 to 3 sentences discussing your concerns. § Use a scatter plot to plot the sale price to the square feet. § Do the same for number of beds to sale price. • You will need to learn about scatter plots to complete this. • For both, turn in the scatter plot &#emdash; if you're using Jupyter, just leave the data inline. § Explore the distribution of properties by number of beds. Plot this using plot() (learn about that function here). PART 2 / Distance metrics and k-Nearest Neighbor § Implement the k-Nearest Neighbor algorithm in Python using the Euclidean distance metric. • Turn on the code for this implementation in Python. • You implementation will take two vectors and return a single number. Use the template : def my_knn(vec1, vec2): # your implementation return d # the_euclidean_distance of vec1 and vec2 § Produce the distance table using your version of kNN for all properties. • To make things easier, please reduce the data vector to just beds, bath, square footage, price, latitude and longitude. • You can use the street as the index. Your final output will look something like this:
Project ID: 11613867

About the project

9 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have two years experience with Python and machine learning, you can see my certificates here [login to view URL] I will implement k-nearest without using frameworks as well.
$35 USD in 1 day
5.0 (1 review)
1.1
1.1
9 freelancers are bidding on average $56 USD for this job
User Avatar
Hi, I am familiar with data analyze and manpulation using Pandas. Please feel free to contact me. Thanks,
$25 USD in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
Hello. I can do it all in the programming language R. The task is very easy and R with this good deal.
$25 USD in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
I'm a PhD student in Engineering with a Master's in Statistics. Expert in Matlab, Minitab Econometric and statistical modeling of pretty much everything you can think of. These include expertise on protocol development, research study designs, sample size calculations, data management, and data analysis using various statistical software’s (i.e. STATA, Eviews, R & SPSS), statistical interpretation and report writing. Currently involved in official approval of internal econometric models that banks are using.
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi i can help you on this. i am expert python/pandas developer with more than 7 years experience. pls reply for starting right away.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
fairfax, United States
5.0
1
Member since Sep 12, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.