@@DataWizardry Appreciate the reply. I just wanted to know so that I can state where the data source came from. Again thank you for all the hard work you put into these videos!
I am curious to know how does one account for the null values in hcahps_answer_percent, num_completed_surveys, survey_response_rate_percent in the hcahps dataset?
Hello, so I have completed this project and would love to put this on my portfolio for recruiters as a data cleaning project. However, I am curious from where this specific dataset came? Also, was it also precleaned?
@@DataWizardry Ok, thanks so much! Your videos have inspired me to give clinical analytics a try. :D I am also curious to know what is the difference between a clinical data analyst, and a health informatics analyst?
Thanks for the lessons. Awesome teaching. In my case, I got an error while trying to export my table as a csv file. Below is the error message: COPY 299925 could not write COPY data: Bad file descriptor C:/Users/adegb/OneDrive/DOCUME~1/PERSON~1/DATAWI~1/practise/result.csv: Bad file descriptor
How the data from manual forms were converted into excel, or word or in sql. It's very hard on people's hands to enter manually every single data from the survey forms. Is there a special way to do this without extracting manually the data from the survey form. Can you imagine if they give you hundred, thousands forms to you?
I was wondering the same thing because the department of health I worked for in my country hasn't done enough to digitise their workflow & systems so I definitely agree manual transcription would be a pain. I was thinking though at this stage or in the future there should be AI or apps that can transcribe the information captured on paper surveys from a scan of the survey. Essentially the program would read the image produced from scanning the survey. For some reason I feel that this program already exists I just don't know what it's called.
Although, I adopted an alternative means of copying the tableau table to a csv file, I still need help with the error while trying to export using the graphical interphase of pgAdmin. COPY ( SELECT * FROM tableau_file ) TO 'C:\\Users\\adegb\\OneDrive\\Documents\\Personal Resource Materials\\DataWizard\\tableau_result.csv' WITH (FORMAT csv, HEADER true);
Hi this is the error I got. Can you please help me? Copying table data 'Hospital_Data.hcahps_data' on database 'postgres' and server 'PG15 (LOCALHOST:5432)' Running command: --command " "\\copy \"Hospital_Data\".hcahps_data (facility_id, facility_name, address, city, state, zip_code, county_or_parish, telephone_number, hcahps_measure_id, hcahps_question, hcahps_answer_description, hcahps_answer_percent, num_completed_surveys, survey_response_rate_percent, start_date, end_date) FROM '/Users/reethika/Desktop/HCAHPS Lesson Files/v1 HCAHPS 2022.csv' DELIMITER ',' CSV ;"" Start time: Fri Mar 29 2024 14:32:57 GMT-0400 (Eastern Daylight Time) ERROR: value too long for type character varying(10) CONTEXT: COPY hcahps_data, line 1, column facility_id: "Facility ID"
Thank you from a junior data analyst in Italy!
Thanks man for this project explanation. I'm also worked as Medical biller and found easy to understand data you're working with.
Thank YOU!
Thank you❤gonna try this
Hey thanks for taking the time to make these helpful videos! Just one question, where did you find the data for the hospital beds csv?
Sure thing. Its from data.cms.gov, they have many datasets. However, I dont recall the exact file.
@@DataWizardry Appreciate the reply. I just wanted to know so that I can state where the data source came from. Again thank you for all the hard work you put into these videos!
Amazing Video, When will the other two videos be uploaded
Videos are all posted now
I am curious to know how does one account for the null values in hcahps_answer_percent, num_completed_surveys, survey_response_rate_percent in the hcahps dataset?
Hi Josh, after I imported the hospital_beds table I noticed that some of the rows have no lines between them, will this cause a problem?
Hi this is the error I got. Can you please help me?
When trying to create the table at the end
Column “provider_ccn” specified more than once
Hello, so I have completed this project and would love to put this on my portfolio for recruiters as a data cleaning project. However, I am curious from where this specific dataset came? Also, was it also precleaned?
Yes, I did some pre cleaning steps before the video. The data comes from data.cms.gov. It's the HCAPS dataset.
@@DataWizardry Ok, thanks so much! Your videos have inspired me to give clinical analytics a try. :D I am also curious to know what is the difference between a clinical data analyst, and a health informatics analyst?
Thanks for the lessons. Awesome teaching.
In my case, I got an error while trying to export my table as a csv file.
Below is the error message:
COPY 299925
could not write COPY data: Bad file descriptor
C:/Users/adegb/OneDrive/DOCUME~1/PERSON~1/DATAWI~1/practise/result.csv: Bad file descriptor
How the data from manual forms were converted into excel, or word or in sql. It's very hard on people's hands to enter manually every single data from the survey forms. Is there a special way to do this without extracting manually the data from the survey form. Can you imagine if they give you hundred, thousands forms to you?
I was wondering the same thing because the department of health I worked for in my country hasn't done enough to digitise their workflow & systems so I definitely agree manual transcription would be a pain. I was thinking though at this stage or in the future there should be AI or apps that can transcribe the information captured on paper surveys from a scan of the survey. Essentially the program would read the image produced from scanning the survey. For some reason I feel that this program already exists I just don't know what it's called.
Although, I adopted an alternative means of copying the tableau table to a csv file,
I still need help with the error while trying to export using the graphical interphase of pgAdmin.
COPY (
SELECT * FROM tableau_file
) TO 'C:\\Users\\adegb\\OneDrive\\Documents\\Personal Resource Materials\\DataWizard\\tableau_result.csv'
WITH (FORMAT csv, HEADER true);
Hi this is the error I got. Can you please help me?
Copying table data 'Hospital_Data.hcahps_data' on database 'postgres' and server 'PG15 (LOCALHOST:5432)'
Running command:
--command " "\\copy \"Hospital_Data\".hcahps_data (facility_id, facility_name, address, city, state, zip_code, county_or_parish, telephone_number, hcahps_measure_id, hcahps_question, hcahps_answer_description, hcahps_answer_percent, num_completed_surveys, survey_response_rate_percent, start_date, end_date) FROM '/Users/reethika/Desktop/HCAHPS Lesson Files/v1 HCAHPS 2022.csv' DELIMITER ',' CSV ;""
Start time: Fri Mar 29 2024 14:32:57 GMT-0400 (Eastern Daylight Time)
ERROR: value too long for type character varying(10)
CONTEXT: COPY hcahps_data, line 1, column facility_id: "Facility ID"
I suspect that perhaps you didn't click the header button @14:51. I get the error you showed when that is not clicked on.