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)
- BinViewChunkedBuilder has incorrect docs
- Series.hist resulting series name changes with include_breakpoint=False, include_category=False HOT 2
- Series.hist adds two bins when specifying bins HOT 1
- data spilled to disk not cleaned up on failure HOT 1
- Cannot serialize polars.LazyFrame (`Expr::RenameAlias cannot be serialized`)
- Big difference in iteration speed over GroupBy object depending on dataFrame construction HOT 1
- Can't `sink_parquet` on a sorted LazyFrame containing decimal columns HOT 2
- `write_database` closes adbc connection HOT 3
- `list_concat([list<T>, list<T>])` gives `list<T>`, not `list<list<T>>` HOT 10
- mismatching schemas when opening csv file HOT 1
- SchemaError for Non-Exiting dtype on Concat HOT 3
- LazyFrame select in 0.20.31 includes hive partition column even when not in specified columns HOT 2
- cross-join should not work on any key HOT 1
- `.sink_parquet()` sometimes panics when `statistics` has `"null_count": False` HOT 1
- separate `pl.list()` and `pl.concat_list` HOT 4
- Panick since first release candidate when expressions in `select()` return a different number of rows HOT 3
- Question, how do you generate and test the Python examples in the README? HOT 2
- min/max operations on i16 list with None elements HOT 1
- Panic when mismatching types between glob files HOT 5
- `write_database` fails for UInts and Time dtypes when ADBC used 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.