Posts

Showing posts from March, 2024

Convert SAS file to csv file.

 If you have file_name.sas7bdat and you would like to convert into normal csv file without   UnicodeDecodeError character issue then below code. >>>>>>>>Python code>>>>>>>>>>>>>>  from dataiku import pandasutils as pdu df = pd.read_sas('/path/file_name.sas7bdat') for col in df.columns:     if df[col].dtype == 'object':            df[col] = df[col].apply(lambda x: x.decode('utf-8') if isinstance(x, bytes) else x) print(df) ======================================================================================== Try this if above one didn't work. import dataiku import pandas as pd, numpy as np from dataiku import pandasutils as pdu import os import glob df = pd.read_sas(dataiku.get_custom_variables()["v_sg_cust_path"]+'/'+dataiku.get_custom_variables()["v_file"]) df= df.apply(lambda x: x.decode() if isinstance(x, bytes) else x) # Write recipe outputs landing = datai...