Completed

Writing Automation Data analytics & visualization script + source code

Hi,

I have attached sample data of real estate deals in Saudi Arabia Riyadh city.. and I want the script contains these requirements:

1- The ability to import 2 xlsx files ( so I can compare between them later )

2- rename all the columns to the following:

[login to view URL]({'سعر المتر المربع' : 'Price_of_meter', 'السعر بالريال السعودي' : 'Price_in_SR',

'المساحة بالمتر المربع' : 'Space_in_meter' , 'تفاصيل الصفقات (رقم الصفقة)': 'TransactionID' ,

'تفاصيل الصفقات التاريخ_ميلادي' : 'Date' , 'تفاصيل الصفقات عدد العقارات - القطعة' : ' Parcel_no' ,

'تفاصيل الصفقات المخطط' : ' Block_no ' , 'تفاصيل الصفقات الحي' : "Area" , 'المدن المدينة' : 'City' }, axis = 1 , inplace = True)

* you can remove the TransactionID column

3- show basic info of the data such as ( Max value row)

4- show the top 10 Areas based on the:

highest Price_in_SR

highest Price_of_meter

Lowest Price_in_SR

Lowest Price_of_meter

the most "Area" that has deals ( based on the duplicated Area )

5- make a comparison to the previous month (rate of change) on the deals

6- make the script flexible and show commit to explaining the code and what it's doing

7- visualize the data

8- feel free to add any sort of analysis

9- Make a line of code to let me add the long & lat for each block & parcel and it's print out the map with the data as an output

10- Identify the outliers and the null data if there is any ( write a basic algorithm )

** Attached file of two months so you can do your sample on them, Show your skills!

* Please share a sample with me.

Skills: Python, Data Science, Data Analytics, Data Visualization, Data Architecture

See more: alibaba clone script source code, send data gps server java source code, google map api script source code deposit, script source code disclosure php, data mining association rule source code, mangafox script source code, real estate portal script source code, data mining project javajsp source code, bluetooth data sharing android application source code, binary based mlm script source code php, script source code redirect ebay description, selling php mlm script source code, hide shell script source code unix, big data mini projects with source code, data warehousing projects with source code, data mining projects with source code, hotel reservation php script source code free, data analytics tools open source, data mining projects with source code in python, data mining projects with source code github

About the Employer:
( 3 reviews ) Riyadh, Saudi Arabia

Project ID: #28399188

Awarded to:

MMohammed1991

this mohamed , freelancer data analysis with experiance in statistics and machine learning , working with in methoslogy starting by cleaning and wrangling data then analysis and ectracting insight end by visulizati More

$140 USD in 7 days
(0 Reviews)
0.0

18 freelancers are bidding on average $177 for this job

(45 Reviews)
6.6
qaisrani123

HI, I am experienced data scientist and machine learning engineer. I used statistical analysis of the data and make prediction based on ML algorithms. I can handle computer vision and NLP tasks using Python(Tensorflow More

$140 USD in 3 days
(38 Reviews)
5.3
umg536

Hi there, I'm bidding on your project "Writing Automation Data analytics & visualization script + source code" Being an expert in Python and matlab programming I can do this project for you. please leave a message on More

$250 USD in 6 days
(9 Reviews)
5.1
lerashestakova02

Hello I just have checked your xlsx files carefully. I am an expert in python, data mining . I have 5 years of experience working in these jobs. So I can give you a good result with this project. Please chat with me f More

$250 USD in 5 days
(9 Reviews)
4.9
TheLKteam

Dear Prospective Client, I've been developing advanced statistical models using R for several years and would like to work on your project. I assure you that you will be impressed by the quality of my work as did ev More

$140 USD in 7 days
(5 Reviews)
3.6
FirmMinds123

We have AI & Data Science team who are highly experienced in Machine learning and Deep Learning and can deliver products as per your requirements. We have done many real time projects like Semantic search engine, Image More

$118 USD in 2 days
(10 Reviews)
3.4
ahmedtryaq

السلام عليكم ورحمة الله ، قرات تفاصيل المشروع وسيسعدني العمل معكم ان شاء الله Dear employer, I'm a certified data analyst, I have a nanodegree in advanced data analysis and statistics. I worked on data analysis in py More

$100 USD in 4 days
(3 Reviews)
2.8
mahdimotlagh6137

Greeting, I can send you a POC on the attached dataset you provided .also I can provide you dynamic visual to add your block and parcel. if you interested let discuss further detail overchat.

$120 USD in 5 days
(1 Review)
2.3
abdelrahmanyfk

Dear, I am Abdelrahman Yasser with bachelor degree of petroleum Engineering and I found my passion in statistical analysis, scoping the data, investigating the numbers and Building a machine learning algorithms to hel More

$80 USD in 4 days
(4 Reviews)
2.0
ChamGam

[login to view URL] are you? I am a Python expert. I have good experience in plot with Pandas. I'd love to discuss more details via chat. Thank you.

$250 USD in 3 days
(1 Review)
2.0
mohandayman

السلام عليكم I am a data science instructor and a professional engineer. I have an idea in mind is to make the data analysis script web based so that you host it in your Server/ laptop ..etc and then all the visualiz More

$170 USD in 17 days
(2 Reviews)
1.4
ABai777

Hi there, Your project is attracting my mind since I am expert with skills on your proposal. I have coding experience with python for 6+ years. I look forward to hearing from you. Thank you

$140 USD in 7 days
(0 Reviews)
0.0
Maskymlap2020

Hi, Thanks for your job posting, and I have interested in your project. I am an experienced ⭐⭐⭐Python Expert⭐⭐⭐ with over 7 years of rich experience. In the meantime, I have successfully done a lot of projects such as More

$250 USD in 7 days
(0 Reviews)
0.0
tska191919

Hi there I read your project in detail . I have work with similar project I can professionally finish it Feel free to chat for more details

$200 USD in 7 days
(0 Reviews)
0.0
irfanaftab

i m expert in ACL scripting. i can develop a script for thi project. looking forward a positive responce

$556 USD in 5 days
(0 Reviews)
0.0
raghurithik981

Hi, I will do your qa task, Could you please assign me I have completed total of 14+ Years of experience in test automation & manual testing could you please review my below LinkedIn profile [login to view URL] More

$140 USD in 7 days
(0 Reviews)
0.0
zahidlearning

I am a data analyst and have done many projects in data cleaning, gaining insights into data and perform visualisation of a dataset. I have advanced knowledge of MySQL and Excel I have also scored 5 stars in SQL at Hac More

$50 USD in 7 days
(0 Reviews)
0.0