Latest revision |
Your text |
Line 411: |
Line 411: |
|
| |
|
| == Advanced Pandas == | | == Advanced Pandas == |
| [https://pandas.pydata.org/pandas-docs/stable/index.html '''Pandas Documentation''']
| |
|
| |
|
| [https://pandas.pydata.org/Pandas_Cheat_Sheet.pdf '''Pandas Cheatsheet''']
| | Christina (I think this is where you want me to sign up? - lol) |
| | |
| '''Tutorials:'''
| |
| * [https://www.packtpub.com/product/pandas-1x-cookbook-second-edition/9781839213106 Pandas Cookbook]
| |
| * [https://tomaugspurger.net/posts/modern-1-intro/ Modern Pandas]
| |
| * [https://www.youtube.com/playlist?list=PL-osiE80TeTsWmV9i9c58mdDCSskIFdDS Video Series of Tutorials]
| |
| * [https://wesmckinney.com/book/ Python for Data Analysis]
| |
| * [https://realpython.com/pandas-project-gradebook/ Make a Gradebook with Pandas]
| |
| * [https://jakevdp.github.io/PythonDataScienceHandbook/ Python Data Science Handbook]
| |
| | |
| '''GPT & Pandas:'''
| |
| * [https://www.sharpsightlabs.com/blog/gpt-writes-bad-pandas-code/ GPT Writes Horrible Pandas Code]
| |
| * [https://github.com/rvanasa/pandas-gpt Package to have GPT Write Good Pandas Code]
| |
| | |
| '''Extra:'''
| |
| | |
| [https://towardsdatascience.com/one-word-of-code-to-stop-using-pandas-so-slowly-793e0a81343c Make Pandas Run Faster with Swifter]
| |
| | |
| '''Class Tutorial:'''
| |
| | |
| '''[https://drive.google.com/file/d/162nO8u2Sr3bPOqoq8KLLhKR8OhmosGjJ/view?usp=sharing Jupyter Notebook]'''
| |
|
| |
|
| == Agent-based modeling == | | == Agent-based modeling == |
Line 524: |
Line 503: |
| Muqing Liu | | Muqing Liu |
|
| |
|
| Introduction to SQL:
| | An overall introduction to SQL: |
| General introduction to SQL https://www.khanacademy.org/computing/computer-programming/sql
| | https://www.khanacademy.org/computing/computer-programming/sql |
| Relational model and the foundation of SQL https://dl.acm.org/doi/10.1145/362384.362685
| |
| Principles and rules for relational database management systems https://www.dcs.warwick.ac.uk/~hugh/TTM/
| |
| | |
| Textbook Guidance to write SQL:
| |
| "The complete idiot's guide to SQL" Steven Holzner This is a beginner-friendly guide introduces SQL concepts and commands. https://www.amazon.com/Complete-Idiots-Guide-SQL/dp/1615641092
| |
| "SQL and Relational Theory: How to write accurate SQL code" C.J. Date
| |
| This book provides a comprehensive guide to understand SQL and relational theory https://www.amazon.com/SQL-Relational-Theory-Write-Accurate/dp/1449316409
| |
| "SQL pocket guide" Jonathan Gennick
| |
| This book is a handy reference for SQL syntax and command https://www.amazon.com/SQL-Pocket-Guide-Usage/dp/1449394094
| |
| | |
| Online courses:
| |
| SQL for beginners https://www.udemy.com/course/sql-for-beginners/
| |
| This beginner-friendly course covers database design, querying with SQL, data manipulation, and database management.
| |
| SQL essential training https://www.linkedin.com/learning/sql-essential-training/
| |
| This course covers basic SQL commands and querying techniques.
| |
| The complete SQL bootcamp https://www.udemy.com/course/the-complete-sql-bootcamp/
| |
| This course covers both SQL fundamentals and advanced concepts. It also includes real-world projects and hands-on exercises.
| |
| SQL for data science https://www.coursera.org/learn/sql-for-data-science
| |
| This course is designed for data science professionals to use SQL for data manipulation and analysis. It covers SQL queries, joins, and aggregations for data science tasks.
| |
| Advanced SQL for query tuning https://www.pluralsight.com/courses/advanced-sql-query-tuning
| |
| This course is for intermediate to advanced SQL users looking to optimize their SQL queries and improve database performance.
| |
| | |
|
| |
|
| SQL tutorial videos: | | SQL tutorial videos: |
| MySQL tutorial for beginners https://www.youtube.com/watch?v=7S_tz1z_5bA
| |
| SQL Tutorial - Full Database Course for Beginners: https://www.youtube.com/watch?v=HXV3zeQKqGY | | SQL Tutorial - Full Database Course for Beginners: https://www.youtube.com/watch?v=HXV3zeQKqGY |
| SQL Advanced Tutorial|Advanced SQL Tutorial With Examples https: //www.youtube.com/watch?v=M-55BmjOuXY | | SQL Advanced Tutorial|Advanced SQL Tutorial With Examples https: //www.youtube.com/watch?v=M-55BmjOuXY |
|
| |
| The use of SQL in data science:
| |
| A Comparative Analysis on different aspects of Database Management System https://www.researchgate.net/publication/352178674_A_Comparative_Analysis_on_different_aspects_of_Database_Management_System
| |
| This paper compared different database management system for handling big data storage and processing tasks.
| |
| Twitter Sentiment Analysis Approaches: A Survey https://www.learntechlib.org/p/217980/
| |
| Analysis of Healthcare Data using SQL https://www.linkedin.com/pulse/analysis-healthcare-data-using-sql-kristopher-bosch/
| |
| SQL for Stock Market Analysis https://medium.datadriveninvestor.com/sql-for-stock-market-analysis-f2145031e125
| |
|
| |
|
| == Command line == | | == Command line == |
|
| |
|
| == Large language models== | | == Building your own language model== |
| | | Dyuti |
| Resources posted by Dyuti
| |
| | |
| -[https://www.techtarget.com/searchenterpriseai/definition/languagemodeling#:~:text=Importance%20of%20language%20modeling&text=It%20is%20the%20reason%20that,other%20to%20a%20limited%20extent What is a language model and why do we need it?]
| |
| | |
| - [https://medium.com/analytics-vidhya/a-comprehensive-guide-to-build-your-own-language-model-in-python-5141b3917d6d A comprehensive guide to build your own language model]
| |
| | |
| LLMs and Research:
| |
| | |
| Large Language Models and Underrepresented Languages [https://arxiv.org/ftp/arxiv/papers/2007/2007.05872.pdf Paper]
| |
| | |
| -Social Biases:
| |
| | |
| -[http://proceedings.mlr.press/v139/liang21a.html Towards Understanding and Mitigating Social Biases in Language Models]
| |
| | |
| - [https://medium.com/@arpitnarain/unmasking-bias-assessing-fairness-in-large-language-models-a722624e4483 Unmasking Bias —Assessing Fairness in Large Language Models]
| |
| | |
| - [https://aclanthology.org/2022.bigscience-1.6.pdf Pipelines for Social Bias Testing of Large Language Models]
| |
| | |
| - [https://huggingface.co/blog/evaluating-llm-bias#evaluating-language-model-bias-with-%F0%9F%A4%97-evaluate Evaluating Language Model Bias with 🤗 Evaluate ]
| |
| | |
| Mitigating Bias:
| |
| | |
| - [https://www.aneesmerchant.com/personal-musings/large-language-models-and-bias-an-unresolved-issue#:~:text=Bias%20in%20LLMs%20can%20manifest,these%20models%20are%20trained%20on. LLM and Biases]
| |
| | |
| | |
| - [https://news.mit.edu/2023/large-language-models-are-biased-can-logic-help-save-them-0303 logic aware models- MIT]
| |
| | |
| LLM and Research:
| |
|
| |
|
| - [https://proceedings.mlr.press/v202/aher23a/aher23a.pdf Using LLMs to Simulate Multiple Humans and Replicate Human Subject Studies] (I am a little dicey about the ethics of it? Would like to hear what everyone else thinks)
| |
|
| |
|
| == Cluster / large-scale computing == | | == Cluster / large-scale computing == |