Data integration

This is related to the term project, but please note that this assignment should be individual work. Also, you need to explore some variables that can be used as a dependent variable and independent variables. More details will be explained below. DatasetFor the project phase 1 report, you already selected a medical condition of your group’s interest, and there should be more than 500 data instances. For the assignment 2, please think about your research question(s). With that being said, you need to explore variables in your dataset. You can change those variables later, but this assignment will help you better understand the dataset. Please visit the official website (Links to an external site.) and Github repository (Links to an external site.) and read the attached appendix document Download attached appendix document(p.1 – 13). MEPS data consists of various variables such as medical condition, socioeconomic factors (e.g., gender, region, race, and family income), and medical expenditure. MEPS data also consist of various files such as person-level (e.g., health status, demographics, and total $$ of care), event-level (e.g., healthcare service use), and condition-level (e.g., medical condition). For the full review of those variables, please look at codebooks (person-level (Links to an external site.)) and condition-level (Links to an external site.)). I also coded those variables (personal-level only) regarding usefulness for analysis (included vs. excluded, Heejun_Inclusion field) and variable type (independent vs. dependent, Heejun_Variable_Type field). You can find my version of the codebook from this link (Links to an external site.). Some dependent variables you can utilize includes but are not limited to: Total health expenditures Total inpatient expenditures Total emergency care expenditures Severity of Illness (attacks/year) Number of School Days Missed (Children) Number of Work Days Missed (Adult) For now, just focus on personal-level (h129.csv) and condition-level (h128.csv) files for exploring variables. At least, find one dependent variable and five core independent variables that can be used for the group project by carefully looking at documents and websites above. The selected independent variables should not be randomly selected. They should be clinically related to your dependent variable. The second step is to preprocess your dataset. Please utilize the “week6_example_code.ipynb” notebook for this process. You need little modification to complete data processing and integration. Select patients (h128.csv) with the your medical condition, drop attributes which are not necessary, and join the condition-level data (h128.csv) and personal-level data (h129.csv). What to Do for the Assignment 2Explore the dataset and find one dependent variable and five core independent variables at least Explain what these variables are and how they are related to the medical condition of your interest Preprocess your data. The preprocessing will include but are not limited to:h128.csvSelect records that are related to your condition of interest by using ICD-9 code and drop duplicated records based on the ‘DUPERSID’ (rowwise selection)
h129.csvSelect attributes that are discriminative and/or meaningful (columnwise selection)
Join two files (h128.csv and h129.csv) after selecting patient instances with the medical condition of your interest
How to writeFor the assignment 2, I will not put constraints on the format. However, you need to present, at least, one dependent variable and five core independent variables. Also, please explain what these variables are and how they are related to the medical condition of your interest. Up to this part, you can write the report in a MS word file. You also need to submit your Jupyter notebook you used for data preprocessing and the final data file (csv). What to includeYour submission of the report should include: Your name EUID Title of the project What I asked you in the “How to Write” Please attach a .docx file for the report and .ipynb and .csv files for the data processing. Again, this is an individual assignment. Grading CriteriaYour reports will be evaluated on the quality of entries. By quality, I do not mean mechanics (e.g., spelling, grammar), but rather content. Your entries should demonstrate reflective and critical thinking, integration of materials and experiences, development of your own research questions, and general intellectual growth. Also, I will look at the data preprocessing steps you implemented.

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Graduate Assistants, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email:

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Graduate Assistants has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.


Essay Writing Services

At Graduate Assistants, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.


Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.


Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.


Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.