Create Pandas dataframe from external source Parameters ---------- data : object, list, dict or str object : pandas dataframe - will be returned as is list : list of folders to load data frame str : filename to load data frome
(self,data=None,df_format="json",csv_dates=None,index_col=None)
| 131 | return self._convert_dataframe(local_file,df_format,csv_dates,index_col) |
| 132 | |
| 133 | def create_dataframe(self,data=None,df_format="json",csv_dates=None,index_col=None): |
| 134 | """ |
| 135 | Create Pandas dataframe from external source |
| 136 | |
| 137 | Parameters |
| 138 | ---------- |
| 139 | |
| 140 | data : object, list, dict or str |
| 141 | object : pandas dataframe - will be returned as is |
| 142 | list : list of folders to load data frame |
| 143 | str : filename to load data frome |
| 144 | dict : data in dict |
| 145 | """ |
| 146 | if data is not None: |
| 147 | if isinstance(data, pd.DataFrame): |
| 148 | return data |
| 149 | elif isinstance(data,dict): |
| 150 | return pd.DataFrame([data]) |
| 151 | elif isinstance(data,basestring): |
| 152 | local_file= self.work_folder+"/data" |
| 153 | futil = fu.FileUtil(aws_key=self.aws_key,aws_secret=self.aws_secret) |
| 154 | futil.copy(data,local_file) |
| 155 | return self._convert_dataframe(local_file,df_format,csv_dates,index_col) |
| 156 | elif isinstance(data,list): |
| 157 | return np.array(data).reshape(1, -1) |
| 158 | else: |
| 159 | raise ValueError("unknown argument type for data") |
| 160 | |
| 161 | |
| 162 |