python-swat

python-swat copied to clipboard

moving data from cas to data frame (pandas) takes forever . i have binary connection

1

I have dataset (2,3 gb) in cas and want to bring to data frame, so I can pandas . this takes more than 30 minutes. we have a large sas...

witkophdw

Connection issue - accessing CAS in containerized Viya 4 environment from local Python client.

2

My Python client is a local Jupyter notebook application running on my laptop. On my server, I have published both the HTTP and Binary CAS Node ports and also exposed...

SundareshSankaran

There's `value_counts` method in the documentation. https://sassoftware.github.io/python-swat/generated/swat.cas.table.CASTableGroupBy.value_counts.html#swat.cas.table.CASTableGroupBy.value_counts There's no such method in the implementation. There's `count()` instead, which is not documented, though.

pkaczynski

`fillna`, `replace`, and `dropna` methods on `CASTable` are implemented but they are missing from the API Reference page in https://sassoftware.github.io/python-swat/api.html

sahbic

crossTab action does not return column names

1

When using the crossTab action with the col= parameter, it does not return the column names. It adds default column names to the SASDataFrame. You need to add an extra...

pestyld

no data limit when using to_frame

2

When you use to_methods like **to_csv**, or any of the plotting methods on a CAS table the **swat.options.cas.dataset.max_rows_fetched** options limits to the default of 10,000. This makes sense to prevent...

pestyld

Await for CAS actions execution

3

Hi, I am developing a backend API which extract data from CAS and returns it to the caller. Since from the backend point of view every CAS action called is...

gygabyte017

How to write large dataframes to a CAS table

1

Hi, I am trying to write a large set of cashflows to a cas table. I am using from_records. I create a SASDataframe and pass it to from_records. However, when...

stanwir

Problem : connect to CAS

3

Hello I've got an issue to connect to CAS with SWAT 1.9.3 which I don't understand. Can u help me please? Regards Fabrice I attach you screenshot from my notebook....

fabricepollet

read_excel can't read datetime values

12

read_excel from SWAT works different that read_excel from Pandas, wich makes me unable to read Date column as a Datetime value. **SWAT**: storm_damage = conn.read_excel("D:\Workshop\VIYAPY\storm.xlsx", sheet_name="Storm_Damage", casout=dict(name="STORM_DAMAGE", replace=True, caslib="Public")) It...

JoannaNawalanySAS