{"id":139,"date":"2023-11-26T09:38:19","date_gmt":"2023-11-26T08:38:19","guid":{"rendered":"https:\/\/www.chemarcus.de\/?page_id=139"},"modified":"2024-10-05T10:01:03","modified_gmt":"2024-10-05T08:01:03","slug":"code-snipets","status":"publish","type":"page","link":"https:\/\/www.chemarcus.de\/?page_id=139","title":{"rendered":"Code Snipets"},"content":{"rendered":"\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-stretch is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<figure class=\"wp-block-table alignfull\"><table><tbody><tr><td><strong>Language<\/strong><\/td><td><strong>Code<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><tr><td>Python<\/td><td>dateipfad_csv = &#8216;&#8230;&#8217;<br>x_werte, y_werte = [], []<br>with open(dateipfad_csv, &#8216;r&#8217;) as file:<br>for line in file:<br>x, y = map(float, line.strip().split(&#8216;,&#8217;)) # trennt die Koordinaten anhand des Kommas<br>x_werte.append(x)<br>y_werte.append(y)<\/td><td>Loading x,y values from a file<\/td><\/tr><tr><td>Excel<\/td><td>=VLOOKUP(lookup_value, table_array, col_index_num=MATCH(2nd_lookup_value, table_array;lookup_type) + 1, [range_lookup]<br><br>=SVERWEIS(Suchwert 1;Suchbereich 1;VERGLEICH(Suchwert 2;Suchbereich f\u00fcr Suchwert 2 ; 0)+1;FALSCH)<\/td><td>2 way lookup<\/td><\/tr><tr><td>Excel<\/td><td>=WRAPROWS(SORTBY(values;RANDARRAY(COUNTA(values))),number_of_columns)<br><br>=ZEILENUMBRUCH(SORTIERENNACH(werte;ZUFALLSMATRIX(ANZAHL2(werte);1));zahl_der-spalten)<\/td><td>distribute a list of values into random columns<\/td><\/tr><tr><td><\/td><td><\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Language Code Purpose Python dateipfad_csv = &#8216;&#8230;&#8217;x_werte, y_werte = [], []with open(dateipfad_csv, &#8216;r&#8217;) as file:for line in file:x, y = map(float, line.strip().split(&#8216;,&#8217;)) # trennt die Koordinaten anhand des Kommasx_werte.append(x)y_werte.append(y) Loading x,y values from a file Excel =VLOOKUP(lookup_value, table_array, col_index_num=MATCH(2nd_lookup_value, table_array;lookup_type) + 1, [range_lookup] =SVERWEIS(Suchwert 1;Suchbereich 1;VERGLEICH(Suchwert 2;Suchbereich f\u00fcr Suchwert 2 ; 0)+1;FALSCH) 2 way lookup&hellip; <a class=\"more-link\" href=\"https:\/\/www.chemarcus.de\/?page_id=139\">Continue reading <span class=\"screen-reader-text\">Code Snipets<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-139","page","type-page","status-publish","hentry","entry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=\/wp\/v2\/pages\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=139"}],"version-history":[{"count":10,"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=\/wp\/v2\/pages\/139\/revisions"}],"predecessor-version":[{"id":161,"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=\/wp\/v2\/pages\/139\/revisions\/161"}],"wp:attachment":[{"href":"https:\/\/www.chemarcus.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}