Comments (4)
Can you provide a minimal working example of the problem?
If we can't see the data that causes the issue it isn't going to be easy to fix it.
from polars.
Can you provide a minimal working example of the problem? If we can't see the data that causes the issue it isn't going to be easy to fix it.
try:
json_files = [pos_json for pos_json in os.listdir(path_to_json) if pos_json.endswith('.json')]
except FileNotFoundError as fnf:
print(fnf)
for json_file in json_files:
print(json_file)
f = open(os.path.join(path_to_json, json_file),"r", encoding="utf-8")
jsondata = json.load(f)
data = pl.DataFrame(jsondata)
df_info = remove_struct_columns(data, remove_keys)
layer = 1
while any([x==pl.Struct for x in df_info.values()]):
print(f"Json columns in layer {layer}: ", [col_name for col_name,dtype in df_info.items() if dtype==pl.Struct])
try:
data=data.unnest([col_name for col_name,dtype in df_info.items() if dtype==pl.Struct], col_suffix= True)
except Exception as e:
print(e)
df_info = remove_struct_columns(data, remove_keys)
layer += 1
# print(data)
df = pl.concat([df, data], how="diagonal_relaxed")
Here is my code, i read many json files to many df with different number of columns, and error catch when i tried to concat 2 df. Error catch on columns with deep nested struct
from polars.
This feels similar to #16536 and #16516. (ShapeError and concatenating dataframes)
from polars.
Do you have structs
in your dataframe?
from polars.
Related Issues (20)
- exception on numpy slicing literal column with object column
- Scanning cloud paths with percentages '%' fails
- Make pl.Enum(...) return type rather than instance HOT 2
- Elementwise check on `join` expressions is too restrictive HOT 3
- Built-in datasets and a function to load them HOT 1
- Python test workflows may fail due to failure to download `torch` dependency HOT 1
- `scan_parquet` does not optimise `slice` or `tail` operations HOT 3
- Apply function to rows of dictionaries in `map_rows`
- De-duplicate decompression in CSV/NDJSON scans
- import numpy with initial null value HOT 2
- Eager/Lazy API alignment: LazyGroupBy vs DynamicGroupBy
- list.any() and list.all() behavior with all null list looks incorrect HOT 3
- pl.from_numpy produces a DataFrame with the wrong values if a schema is given HOT 1
- Assigning multiple columns on same condition, splitting struct into multiple columns? HOT 2
- Add a `replace` method to the `expr.name` attribute
- Arrow PyCapsule TypeError: __arrow_c_stream__() missing 1 required positional argument: 'requested_schema' HOT 1
- Add a `casefold` method to the `expr.str` attribute
- Thereโs no Right in JoinType enum HOT 3
- Polars does not allow reading a dataframe from piped csv output of another process HOT 1
- Add option for n_unique() to ignore None values HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from polars.