Coding with Python-Pandas


• Step1: Examining and loading data. Write Python code in JuPyteR notebook to examine ‘[url removed, login to view]’, determine the content and format, and then load the data into a Pandas DataFrame. Every line of code should be explained with ‘MarkDown’.

• Step 2: Parsing all the columns in the DataFrame. Parse the loaded data into a Pandas DataFrame that contains the following columns (pay attention to those have examples):

Column Description

date Date of house sold, e.g., 20140502T000000

price House sold price.

bedrooms Number of bedrooms in the house.

bathrooms Number of bathrooms in the house.

sqft_living Living area in square feet, i.e., this is equal to the sum of basement area (i.e., sqft_basement) and the above living area (i.e., sqft_above)

sqft_lot Area of lot in square feet

floors Number of floors in the house

waterfront Whether it is a waterfront house.

view Number of views in the house.

condition Condition of the house.

sqft_above The above living area in square feet

sqft_basement Area of basement in square feet

yr_built Year the house is built

yr_renovated Year the house is renovated

street Street address the house locates, e.g., “3140 Franklin Ave E”

city City the house locates, e.g., “Seattle”

statezip State the house locates and zip code, separated by a space. For example, “WA 98115” (WA is the abbreviation of Washington)

country Country the house locates, e.g., “USA”

After the data is parsed and loaded into Pandas, you should have a DataFrame where each row is a record, and each column is an attribute. Each column should have a proper label (i.e., column name) and data format (i.e., integers, strings, floating point etc).

• Step3: Saving data. Save parsed data into a CSV (Comma Separated Values) file.

Taidot: JSON, Python

Näytä lisää: python coding language, pandas python, programmers python coding experts, matlab or python coding job, city province state country zip code, python coding exercises, easy python coding, PYTHON CODING, global travel distances air country country, coding selected country state city, bluetooth proximity python coding java, web programming city province state country listings, country country distances, browse country country penpals email addresses yahoo 2009, python coding bf2

Tietoa työnantajasta:
( 4 arvostelua ) Canning Vale, Australia

Projektin tunnus: #11916174

Myönnetty käyttäjälle:


Hello, my name is Rastko, I'm from Serbia, but my English is quite good, so there won't be any communication problems if you hire me. I'm a Python developer and I have experience in working with pandas library, Lisää

$30 AUD 1 päivässä
(15 Arvostelua)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$28 AUD 1 päivässä
(27 arvostelua)

Hi, I am proficient in Python, Numpy / Pandas and use IPython / Jupyter notebook for most of my work. I would like the opportunity to work with you on this project. Please feel free to ping on chat to discuss more. My Lisää

$25 AUD 1 päivässä
(8 arvostelua)
$25 AUD 1 päivässä
(2 arvostelua)
$24 AUD 1 päivässä
(0 arvostelua)
$25 AUD 1 päivässä
(0 arvostelua)

Hello There, I have expertise in this. If you need to see any reference of my work then please see these links. Project Report Automation - [login to view URL] Lisää

$50 AUD 3 päivässä
(0 arvostelua)

[login to view URL] will be quite easy for me to convert your JSON file to the CSV. I can comment every string of code for you so you will undestand how to do the same thing. Time for this task is less than 1 day. Feel free to di Lisää

$15 AUD 1 päivässä
(0 arvostelua)

I have done projects in python in data science and big data field. Worked with jupyter notebook and pandas.

$25 AUD 1 päivässä
(0 arvostelua)

Hello ! I am a data scientist working in an IT company. I am new to So please don't judge me by looking at my profile. I am pretty confident that I am the right candidate for this project. I've already Lisää

$25 AUD 1 päivässä
(0 arvostelua)