Can this be done with SQLAhclemy / Python?

jake wong Published at Dev

jake wong

I'm trying to create a database in SQL, with python. Was wondering if it would be possible to group things together like the below image? (I know we can do this in Excel. But I was wondering if it would be possible to do it in SQL?)

If it is not possible to do this in SQL, What do you suggest I can do that would provide similar results?

David Gomes

Yes, it is possible to achieve that with SQL. All you have to do is create a table like this:

CREATE TABLE data (
    names TEXT,
    counter INT,
    ratio1_2012 INT,
    ratio2_2012 INT,
    ratio3_2012 INT,
    ratio4_2012 INT,
    ratio1_2013 INT,
    ...
);

Of course, this is not a very "pretty" solution and so it might be better to have one table per year:

CREATE TABLE data2012 (
    names TEXT,
    counter INT,
    ratio1 INT,
    ...
)

...

In the end, which approach you want to take depends on how much data you have and how much of a concern is space vs query execution speed to you. If you have two tables, you have a lot of duplicated data (all names for instance).

Visually, either method works fine you just have to adapt the frontend code in the necessary way.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-3

Comments

0 comments

From Java

Related Related

Article

Can this be done with SQLAhclemy / Python?

Can this be done with SQLAhclemy / Python?

Can Conditional Variable Assignment be Done in Azure Pipelines?

Can routing urls in Spring framework be done easier?

Can't tell when Jasmine is done running

Can C# execution of Python script be done faster by re-using process?

Notify a python script that a process is done

Can this be done with Scala macros?

Can be done more pythonic?

How can this effect be done efficiently?

Potentially complicated query for hasMany relationship; can this be done?

Can this be done with formatting strings alone?

python algorithm to be done in a pythonic fashion?

Can I run ffmpeg from my Python code and return a signal when it's done compressing?

Call subprocess "ls -l folder | wc -l" in python can't be done

Executing python script from a PHP site -- do I need Django? Can it be done on a raspberry pi?

Can this be done with regex?

Python: Can this be done in a single list comprehension statement

Can generating permutations be done in parallel?

Can this be done faster with numpy?

Can this be done with STM?

Can OLAP CUBE be done in HBase?

Can Hotel management done in sharepoint?

jQuery - Can threads/asynchronous be done?

Can this be done in a one-liner?

Can C# execution of Python script be done faster by re-using process?

python algorithm to be done in a pythonic fashion?

How can use .done jquery

Call subprocess "ls -l folder | wc -l" in python can't be done

Can this be done with regex?

Can the same query be done with Pivot?