Writing Automation Data analytics & visualization script + source code
$30-250 USD
着払い
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.
プロジェクトID: #28399188
プロジェクトについて
アワード:
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 もっと
16人のフリーランサーが、平均$168 で、この仕事に入札しています。
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 もっと
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.
السلام عليكم ورحمة الله ، قرات تفاصيل المشروع وسيسعدني العمل معكم ان شاء الله 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 もっと
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 もっと
السلام عليكم 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 もっと
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
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
i m expert in ACL scripting. i can develop a script for thi project. looking forward a positive responce
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 もっと