sql - python - create table and insert data from csv -

-

i have numerous different .csv files structured - 

"company", "column2", "column3" "abc corp", "john doe", "212,345" "dbe ltd", "victor smith", "234,345"

i understand how write these csv files table, want write these new table may not know columns need dynamically scan .csv file column names first row create table portion.


Comments

Post a Comment

Popular posts from this blog

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

c++ - Visual Leak Detector detects leak on new blank MFC project -

-
i installed vld try , debug c++ mdi mfc application in visual studio 2008. vld reported memory leak , no matter did not correct issue, created brand new blank project (mdi mfc) , memory leak still showing up. modification made writing #include <vld.h> in main project.h file. documentation says doesn't matter file, here output after execution (simply selecting file/exit , doing nothing else). 'project.exe': loaded 'c:\users\masterhd\documents\visual studio 2008\projects\project\debug\project.exe', symbols loaded. 'project.exe': loaded 'c:\windows\syswow64\ntdll.dll' 'project.exe': loaded 'c:\windows\syswow64\kernel32.dll' 'project.exe': loaded 'c:\windows\syswow64\kernelbase.dll' 'project.exe': loaded 'c:\windows\winsxs\x86_microsoft.vc90.debugmfc_1fc8b3b9a1e18e3b_9.0.21022.8_none_9b54853441e399d5\mfc90ud.dll', symbols loaded. 'project.exe': loaded 'c:\windows\winsxs\x86_microso...
Read more

php - facebook and github login HWIOAuthBundle and FOSUserBundle in Symfony2.1 -

-
i have followed tutotial http://m2mdas.github.io/blog/2013/11/21/integrate-hwioauthbundle-with-fosuserbundle/ make github login work, seems working when clicked login land on github login page, , see 1 user registered on github application in github dashboard. not authencated in symfony. on symfony tool bar on bottom still says anonymous user, plus new row not added table fos_user. for facebook login, when click on generator login link facebook, gives me error "given url not permitted application configuration.: 1 or more of given urls not allowed app's settings. must match website url or canvas url, or domain must subdomain of 1 of app's domains." another doubt had in tutorial, in routing.yml says put, hwi_github_login: pattern: /secure_area/login/check-github as there no controller or resource specified, supposed put here controller action path or resource? config.yml fos_user: db_driver: orm # other valid values ...
Read more