Python

Hey /prog/,

How can I do this?

We can represent tables in Python as lists of lists as the following:

X0 Y0
X1 Y1

We could use [["X0", "Y0"], ["X1", "Y1"]].

Write a function called merge_tables, that consumes two list of lists (table1 and
table2) and produces a list of lists that corresponds to the merged version of the two
consumed tables. In order to merge the tables we follow certain rules:

• The first column of both table1 and table2 is called the key and the same key
value can occur in both tables or in only one table.

• If table1 has m columns and table2 has n columns then the produced table
will have m+n-1 columns (the key should not be repeated twice in the
produced rows).

• The columns in the produced table should be in the same order as all the
columns in table1 followed by all but the first column in table2.

• Every row in a table has the same number of columns.

• The rows in the produced table do not have a specified order.

• If the the same key value occurs in both tables the two rows should be merged
in the produced table. The key links the two tables.

• There may be multiple rows in table1 or table2 which contain the same key.
In this case the rows should be merged with all rows from the other table with a
matching key. See key “D” in the example below.

• If a key in one table has no match in the other table the value None should be
placed in the missing column fields. The first column in the produced table
should always be the key.

• If both consumed tables are empty then the empty table is produced.

• If only one of the consumed tables is empty then either table1 or table2 is
produced, whichever one is non-empty.

With the example,

merge_tables([["A", 11], ["B", 22], ["D", 33], ["D", 44], ["E", 55]], [["A", True, 5.0], ["B", False, 8.0], ["C", True, 4.0], ["D", False, 2.0], ["D", True, 1.0]]) =>

[["A", 11, True, 5.0],["B", 22, False, 8.0], ["D", 44, False, 2.0], ["D", 44, True, 1.0], ["D", 33, False, 2.0], ["D", 33, True, 1.0], ["C", None, True, 4.0], ["E", 55, None, None]]

Easily.

Is this from the new shitty FIOC based SICP?
Just use Scheme, like a real programmer would, and not a toy language like FIOC.

http://stackoverflow.com

Just use Python as an interface to SQL.

for b in t2:
  done = false
  for a in t1:
    if b[0] == a[0]:
      a += b[1:]
      done = true
  if not done:
    t1.append(b)

Hmm...

>>6
This outputs
[['A', 11, True, 5.0], ['B', 22, False, 8.0], ['D', 33, False, 2.0, True, 1.0], ['D', 44, False, 2.0, True, 1.0], ['E', 55], ['C', True, 4.0]]

it should output
[["A", 11, True, 5.0],["B", 22, False, 8.0], ["D", 44, False, 2.0], ["D", 44, True, 1.0], ["D", 33, False, 2.0], ["D", 33, True, 1.0], ["C", None, True, 4.0], ["E", 55, None, None]]

>>6
Nice one, retard!

>>7 gets it ^^

>>10

this is an easy one-liner in javascript

why is python even relevant?

>>12
I'm interested in knowing how this is done in Javascript. Wanna shed some light?

>>12
this is an easy one-liner in python

why is javascript even relevant?

ספר זה מלמד JavaScript צעד אחר צעד. ספר זה מלמד תכנות ומיועד למי שלמד HTML בעבר ורוצה לדעת לתכנת אתרים דינמיים. הספר מתחיל מתוכניות פשוטות מאוד, ובכל נושא יש דוגמאות, תרשימים וכלים העוזרים להבנת הנושאים. למי שלמד את הפרקים הראשונים או שלמד JavaScript בעבר, ספר זה מלמד תיכנות ברמה גבוהה ושימוש בספריות JavaScript.

שפת JavaScript נמצאת בשימוש במיליארדי דפים ברשת התורמת לשיפור העיצוב, לתקיפות טפסים, זיהוי דפדפנים, יצירת אנימציות וכו'. נוסף לכך, ככל שהזמן הולך, הישומים באינטרנט הופכים לפופולריים יותר. דוגמאות טובות לכך הם השירותים של גוגל כמו גוגל דוקס.

>>15
What an horrible language

>>16
I know, right.

>>16
What an shitty english

>>16
Dumb goy.

>>16
Please don't detonate yourself!

>>20
I'm a spic, we don't go boom.

But really, is awful... not like beautiful japanese, or even korean, by far a superior and prettier language.

>>21
I'm a spic too, and I'm the I love JEWS guy.

Hebrew is kind of intriguing and Corea eat dog nida.

>>1-21
pythonic dubz

>>23
I stole your dubs!

>>24
I STOLE YER DERBS.

>>21-22
What the fuck is a ``spic'' and why do you keep using what seems to be a derogatory racist term when referring to yourself?
I don't get it.
Are you somewhat confused of being a mix between noble and glorious amerindians, violent greedy colonizing half-semites spaniards, filthy jews slave traders and garbage niggers? Call yourself a fucking human and get over it.

>>26

A spic is something, which you put around your dick.

>>27
Shalom, Hymie!

>>28
But it is true. I put it around my dick. It feels good.

>>26
I call myself a spic (and a nigger) because they're short and kawaii words. Calling myself a Hispanic individual or an African-American individual would be gay.

>>30
Too bad that ``beaner'' is a Mexican-only word. It's funny, short and even cute as far as pejoratives go.

Sudaca will have to do.

>>30
Who is asking you to call yourself anything?

Oh, Danny boy, the JEWS, the JEWS are calling

>>30
As a Gay Anus Haxer, I am offended by these spics and niggers.

>>31
Sudaca doesn't sound as kawaii as spic.

Really, I can't see myself visiting a nigger-themed forum (say, a rap forum) and yelling "hello everybody I'm a white-ass, a cracker!!!"

Also I'm pretty sure nobody ever called you a spic here. We have many racisms, but we don't have that one.

As a non-humanities student, I don't get offended by words.

>>36
and that's racist.

/prog/ is not your personal debugger

>>38
Is it racism if I hate everyone equally?